Hot answers tagged

3

At least I typed my own text LOL In the Filter settings of a View you can only use [Today] as is, you can do simple +- calculations but you can not use Functions. So you need to add two Calculated Columns calculating january1st =DATE(Year([YourDate),1,1) and december31st =DATE(Year([YourDate),12,13) and then compare in your View Filter if [Today] ...


2

Folders are also counted as Items and as such filter rules also apply to them. Since the folder does not have the user on the column it is not showing it to them. What you can do is add another filter (using OR) and set the logic to show content type Folder. This means it will show ALL folders as well as all items that have the user = Work Allocated


2

You're writing it wrong. You need to use $filter= to filter results.


1

I found the solution - In the List View set the following filters: Filters: a) Modified - Less than or Equal to - [Today] b) Publish Date - Less than or Equal to - [Today] c) Publish - Begins with - Yes Sort by Modified (Descending) Item Limit = 1


1

Install the OData Query Builder available (for free) in the App Store https://store.office.com/odata-querybuilder-WA104051159.aspx?assetid=WA104051159


1

You can try this workaround: 1) Create a calculated column StartYear = DATE(YEAR([your date field]),1,1) 2) Create a calculated column EndYear = DATE(YEAR([Expiry Date]),12,31) 3) Create a View and Filter: StartYear is Less Than or Equal to [TODAY] AND EndYear is Greater Than Equal To [TODAY] Source.


1

You will need to use some workaround as mentioned below. 1) Create two calculated columns Start Year and End Year 2) Start Year = DATE(YEAR([Expiry Date]),1,1) 3) End Year = DATE(YEAR([Expiry Date]),12,31) 4) Create a View and Filter Condition will be Start Year is Less Than or Equal to [TODAY] AND End Year is Greater Than Equal To [TODAY]


1

No, if you put HTML inside a Calculated Column (and set the datatype to anything but single-line of text to output the HTML) the bare HTML code itself will be displayed in the filter choices. Only in the View is the HTML code not escaped; it will appear as bare HTML on Forms, in Alert emails and more places. A way too complex workaround is to add ...



Only top voted, non community-wiki answers of a minimum length are eligible