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.