We are on SharePoint 2013 externally and Office 365. I am trying to make a calculated column to filter a list on specific dates but it keeps error. Is it possible to calculate on dates such as Between 01/04/2016 AND 31/08/2016 ?
Asked
Active
Viewed 44 times
0
-
are you want to filter list by date range? – SP Developer Sep 13 '16 at 07:41
-
2Do you want to filter the list? Also what is formula that you are using and getting error – Gaurravs Sep 13 '16 at 07:48
-
Intan As above I want to make a formula in a column to result in yes or no using any actual dates but not using today. yes to filtering on a date range – Ian H Sep 13 '16 at 08:27
-
Gaurravs I put the formula there in the question – Ian H Sep 13 '16 at 08:28
1 Answers
0
If you want to filter some elements of the list, then You can create a view with some filters, that are based on a date.
This article can also be helpful`
-
Marcin O I wish to use actual dates in a calculated column because I can then change the dates to suit – Ian H Sep 13 '16 at 08:26