date format

[Billy_u]

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

[Frank_Hartmann · Accepted solution]

try like this:

Date(Alt( Date#(field,'DD/MM/YYYY'), Date#(field,'DD-MM-YY') ),'DD/MM/YYYY') as MixDate