Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have excel sheets where the data field arrives in two different formats, I would like both to format them in a single format, I'm trying this:
Date (Date # (field, 'gg-mmm-yy' OR 'DD / MM / YYYY'), 'DD / MM / YYYY') as Data,
but it doesn't work for a format type: 12-Jan-19,
have you suggestions?
thx,
Billy
try like this:
Date(Alt( Date#(field,'DD/MM/YYYY'), Date#(field,'DD-MM-YY') ),'DD/MM/YYYY') as MixDate
try like this:
Date(Alt( Date#(field,'DD/MM/YYYY'), Date#(field,'DD-MM-YY') ),'DD/MM/YYYY') as MixDate