Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
You can use Date(DateField,'DD/MM/YYYY')
BR
Ariel
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?
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.