Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Problem with date format

Highlighted
5 - Atom

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....

Highlighted
ACE Emeritus
ACE Emeritus

Hi @aravinds

 

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

Hope that helps!

John

Labels