Problem with date format

[aravinds]

I have a excel file with date included in the file name, example: "Monthly Data 05-16-2018"

I am using a formula to bring out the date --- Date = Right([File Name],10)     Output is: 05-16-2018   which is a v-w string data type.

How can I change that to Date time format

Any help is appreciated....

[JohnJPS · Accepted solution]

Hi @aravinds

Look under the Parse tab for the "DateTime" tool... it should do the trick.

Hope that helps!

John