Text to Date conversion
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!