This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The date column multiple formats have dd/mm/yyyy hh:mm:ss , mm/dd/yyyy hh:mm:ss ,dd-mm-yyyy hh:mm:ss and mm-dd-yyyy hh:mm:ss
I want the date format in mm/dd/yyyy hh:mm:ss. Could you please help me on this
While it is easy to deal with the - vs / issue, it is very hard to deal with mm/dd vs dd/mm automatically as there is no way to tell the difference between 06/12 mean 6th December of 12th June.
You can create a rule for it if you know which one is more likely.
Using a formula tool:
iif( ToNumber(left([Input],2)) < 13,
will parse all the ones which try month day format if the first two digits are between 1 and 12, regardless of the separator.
Could you post some sample data?
Hi @jdunkerley79 ,
Thanks for response and sorry for late reply
04/07/2020 14:40:40 PM
16/04/2020 15:50:40 PM