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.
LVL 1
coptechsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rainer JeschorCommented:
Hi,
please try the following formula (assuming you use En-Us date Format and the string starts with "MM/DD/YYYY"):
=DATE(MID(Title,7,4),LEFT(Title,2),MID(Title,4,2))

Open in new window


HTH
Rainer
coptechsAuthor Commented:
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?
Rainer JeschorCommented:
Ok,
your sample above looked like having a 4 digits year.
So if your text column just has 2 years digits AND your dates are > 2000 then the following will work:
=DATE("20" & MID(Title,7,2),LEFT(Title,2),MID(Title,4,2))

Open in new window


HTH
Rainer

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
coptechsAuthor Commented:
Awesome! Thank you so much for your help.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.