Hot answers tagged filter
Yes you can. Just go to modify view page, and add the filters like this: closing date is greater than or equal to [Today] publish date is less than or equal to [Today]
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] ...
You're writing it wrong. You need to use $filter= to filter results.
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
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]
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.
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 ...
Install the OData Query Builder available (for free) in the App Store https://store.office.com/odata-querybuilder-WA104051159.aspx?assetid=WA104051159
Only top voted, non community-wiki answers of a minimum length are eligible