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?
You can use Date(DateField,'DD/MM/YYYY')
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?
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.
Retrieving data ...