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.
Solved! Go to Solution.
I found the solution: DateTimeParse([Date],'%Y-%m-%dT%H:%M:%S')