Text to Date conversion

Options
sandrajcp
sandrajcp Member, ALL USERS, Community Member Posts: 2 New Contributor
in Extensibility

Hi All,

 

My import has dates in following format: "01-sep-20" and I want to convert it to monthly date "Sep 20". I was trying combinations of PERIOD, DATE, VALUE:

 

PERIOD(DATE(VALUE(LEFT('DATE (txt)', 2), MID('DATE (txt)', 4, 3), VALUE(RIGHT('DATE (txt)', 2))

 

But it seems that it won't work because it doesn't recognize "sep". Is there some function that would translate "sep" to 09?

 

Thanks a lot!

Sandra

Tagged:

Categories