DateTime parse - "2025-08-26T09:02:59.286Z"

[Katy_Holder-Vale]

Hi,

Not too sure if I am just missing the simplest of solutions but can someone turn this string format into a DateTime values for me please?

The inputs are like "2025-08-26T09:02:59.286Z" and "2025-08-28T13:02:02.254Z" with the outputs being - 26-08-2025 09:02:29 & 28-08-2025 13:02:02.

Many thanks in advance,
Katy 

[aatalai]

try the formula tool with todatetime(field/values) 

[davidskaife · Accepted solution]

Hi @Katy_Holder-Vale 

There are a couple of ways of doing it, i've shown two of them below. You can either convert the string into Alteryx DateTime using the Datetime tool, and then use a Formula tool to convert it to the format you want, or using just the Formula tool parse it and format it in one go:

Note as you want the date in a specific format you have to keep the data type as string.