date time

[VeronicaElse]

Hello,

I don't know why Alteryx isn't converting the date time correctly! it changes the time to 1900 or 1899! I did data cleanse bc there are some leading spaces in front of the time. Then I did DateTime Parse to convert to the yyyy-MM-DD hh:mm:ss for those dates

[MarqueeCrew]

@VeronicaElse ,

i can see how that could frustrate you. I've never seen it myself.  

Do you have a specific input value that is creating this condition?

 Cheers,

 mark