Converting String Date using Formula Tool DateFormat

[wilsonn]

Hello,

I am working on converting a series of string values to date values. I was able to get it working using the DateTime parse, but I have a few variables that will need to be converted. It seems like Formula Tool would be ideal, but I am getting an error.

This is the formula I am current attempting:

DateTimeFormat([Date],"%Y-%m-%dT%H:%M:%S")

Here is the error:

ConvError: Formula (2): DateTimeFormat: "2023-01-01T22:02:52Z" is not a valid Date or Time

Thank you for any assistance you are able to provide.

[wilsonn · Accepted solution]

I found the solution: DateTimeParse([Date],'%Y-%m-%dT%H:%M:%S')