ERROR ON FORMULA - PARSING

[kathbanc]

Hi Good Day,

I'm having this error on parsing DATETIME : 

FORMULA TOOL SYNTAX : datetimeparse([actual_departure_dt],'%b %d, %Y %I:%M:%S %P')

ERROR : Formula (2) DATETIMEPARSE: Cannot convert "2/3/2022 10:19" to a date/time with format "%b %d, %Y %I:%M:%S %P" and language "English": Invalid month: '2/3/2022 10:19' -- expected at least three letters

INPUT : 2/3/2022 10:19 

OUPUT : 2022-02-03 10:19:00.000

Thank you in advance 

[Raj]

"datetimeparse([Date], "%m/%d/%Y %H:%M")"
use this formula this will work

[kathbanc]

Hi @Raj , 

the output is only : 2022-02-03 10:

[Raj]

2022-02-03 10:19:00 I get this as an output

[Raj]

Find attached

[binuacs]

@kathbanc The above formula will convert your input data to DateTime format YYYY-MM-DD HH:MM:SS, I think Alteryx doesn't support milli seconds format in DateTime type