In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Date format

joshikalyani
8 - Asteroid

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

 

TRADE_DATETRANSACTION DATETIME
18-MAY-2021 08.25.09.000000000 AM2021-05-18T08:25:09.000+0000
05-OCT-2021 01.33.18.000000000 PM2021-10-05T13:33:18.000+0000
11-AUG-2021 01.03.28.000000000 PM2021-08-11T13:03:28.000+0000
3 REPLIES 3
apathetichell
19 - Altair

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
18 - Pollux
18 - Pollux

Done!

Screenshot 2024-04-15 130050.png

apathetichell
19 - Altair

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.

Labels
Top Solution Authors