Change 'MMM DD, YYYY' to regular date format

[johnnyjohn]

I am receiving a date as a string that look like that.

Mar 19, 2020

How can I convert this to a usable date format?

Thanks

[martinpohl · Accepted solution]

load

date(date#(Yourfield,'MMM DD, YYYY')) as datefield

regards