We've created a view of expired pages showing last reviewed date and scheduling end date.
Our last reviewed date can be formatted to just show the date, but can't seem to do this with the scheduling end date. Is there a way?
5
-
Just go to the column settings and select Show Date only instead of Date and Time– Ankit KumarCommented Dec 15, 2016 at 10:48
-
Thanks Ankit, I can do this with our last reviewed date, but not the scheduling end date - there's no option in the settings to change this.– MarcCommented Dec 15, 2016 at 11:13
-
In that case you can have a calculated column in the view which takes only date from the schedulling end date and display this calculated column and hide the schedulling end date column– Ankit KumarCommented Dec 15, 2016 at 11:16
-
OK, thanks Ankit, nice workaround. I used =IF(ISBLANK([Scheduling End Date]),"",[Scheduling End Date]) in the formula to bring across the date (not all docs have expiry date).– MarcCommented Dec 15, 2016 at 11:46
-
cool ...let me put it that as an answer...you can mark it as an answer to the question– Ankit KumarCommented Dec 15, 2016 at 11:55
Add a comment
|
1 Answer
First option will be to go to the column settings and select Show Date only instead of Date and Time. If Settings not available you can have a calculated column in the view which takes only date from the schedulling end date and display this calculated column and hide the schedulling end date column.
answered Dec 15, 2016 at 11:56
