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.
I'm a new Alteryx user and I have a doubt:
There is a column with thousands of data like the following:
30-Mar-20 09:15:10 am
30-Mar-20 09:30:11 am
(there are results in am and pm time)
The data type is:
I have been trying many ways but I cannot convert it to a DateTime format.
Thanks in advance.
Hi @Adolfo ,
try the formula:
DateTimeParse([Field1], '%d-%b-%Y %X')
The field should be defined as DateTime. %d is the specifier for day, %b is the short month name, %Y is the year in 4 digita and %X the time with am/pm.
Let me know if it works for you.
Here is the sample workflow. Hope this is helpful.
Hi @Adolfo ! You can use the date time tool with the Custom format of: %d-Mon-%Y %I:%M:%S %p