coptechs
asked on
Filter Sharepoint list to show today and future
I have a Sharepoint (SP Online) list that has a single text column with a combination of date and text (i.e.: "01/07/2015 TRAINING"). I have several training dates and want to show only the current days training participants and those in the future. I do not want to display anything in the past.
I created a calculated column to pull the date portion of the text column using this formula =LEFT([Training Date],8) - and set the Data Type Returned from this formula = Date & Time. I now have a column I called Calculated Date with just the date in a date/time format.
I tried to create a filter on the view to filter on the Calculated Date column when it is greater than or equal to [Today]. Unfortunately it doesn't seem to work. The only difference between my Calculated Date column and a system generated date column is that my column has leading zero's. For example where SP would display Created Date as 1/7/15, my calculated column displays it as 01/07/15.
I can't seem to find the problem here. Any assistance would be appreciated. I have Sharepoint Designer, but I can't get into any coding to do this.
I created a calculated column to pull the date portion of the text column using this formula =LEFT([Training Date],8) - and set the Data Type Returned from this formula = Date & Time. I now have a column I called Calculated Date with just the date in a date/time format.
I tried to create a filter on the view to filter on the Calculated Date column when it is greater than or equal to [Today]. Unfortunately it doesn't seem to work. The only difference between my Calculated Date column and a system generated date column is that my column has leading zero's. For example where SP would display Created Date as 1/7/15, my calculated column displays it as 01/07/15.
I can't seem to find the problem here. Any assistance would be appreciated. I have Sharepoint Designer, but I can't get into any coding to do this.
ASKER
Rainer-
Looks like that is on the right track, however it is showing me the year as 1915 instead of 2015. What can I tweak to fix that?
Looks like that is on the right track, however it is showing me the year as 1915 instead of 2015. What can I tweak to fix that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Awesome! Thank you so much for your help.
please try the following formula (assuming you use En-Us date Format and the string starts with "MM/DD/YYYY"):
Open in new window
HTH
Rainer