Date format

[joshikalyani]

I'm trying to convert below TradeDate  to Transaction datetime but now working in alteryx

TRADE_DATE	TRANSACTION DATETIME
18-MAY-2021 08.25.09.000000000 AM	2021-05-18T08:25:09.000+0000
05-OCT-2021 01.33.18.000000000 PM	2021-10-05T13:33:18.000+0000
11-AUG-2021 01.03.28.000000000 PM	2021-08-11T13:03:28.000+0000

[apathetichell]

I don't remember millisecond and sub millisecond support in Alteryx - but according to this - https://help.alteryx.com/current/en/designer/functions/datetime-functions.html#example-6515814-8 something like:

datetimeparse([TRADE_DATE],"%d-%b-%Y %I.%M.%S.%9 %P") - should work. It does not work in 2021.4

[alexnajm]

Done!

[apathetichell]

if not you'd have to make a decision between if you want timestamps without miliseconds (second level) or formatted non-time data which looks like your desired output but is useless in datetime formulas.