converting multi-format date field

[#1]

Hi,

I have a column storing date, with different format, it could be either DD/MM/YY or MM/DD/YY, is there a way to transform them to be all into same format?

Thanks.

[ariel_klien]

Hi

You can use Date(DateField,'DD/MM/YYYY')

BR

Ariel

[swuehl]

Please have a look at the alt() function in the Help file.

But how do you know, if 01/02/2013 is Feb 1st or Jan 2nd?

[#4]

Hi All,

That's the tricky part, all dates are in the same columns.

Just want to check if there's a quick way before correcting the data itself.

Thanks.