Convert a string to a Date

[Anonymous]

Hi Community,

Maybe someone could help me...

I have a string field called 'Departure' populate like that = [January 11th 2018  12:00:00]

I would like to convert it into a Date field/dimension => [01/11/2018]

Maybe someone nice could help me...

my brain is going to expose

Thanks a lot,

Thomas

ps: currently I get only the number of the month with the formula below:

=wildmatch((LEFT(Departure,FindOneOf(Departure,' '))), 'ja*','fe*','ma*','April','May','Jun','July','August','September','October','November','December')

[maxgro]

you can use the LongMonthNames

Set LongMonthNames =

          'January;February;March;April;May;June;July;August;September;October;November;December';

load

     field,

     date(

     date#(

          subfield(field, ' ', 1) & ' ' &

          left(subfield(field, ' ', 2),2) & ' ' &

          subfield(field, ' ', 3)

          ,

          'MMMM DD YYYY')

          ,'DD/MM/YYYY') as newfield

inline [

field

January 11th 2018  12:00:00

January 01st 2018  12:00:00

February 02nd 2017  03:00:00

];

Roman Emperors and the Month Names