Convert Date time string

[KCAgentProvocateur]

Hi there, 

I'm having issues with the formula below to convert using the Date Time tool:

2020-01-08T17:53:35.000Z

I tried using: %Y-%m-%dother%H:%M:%S but the value came out as [null]

Id appreciate the help!

Thanks,

Kerry

[fmvizcaino · Accepted solution]

Hi @KCAgentProvocateur ,

Try using this custom format in date time tool.

%y-%m-%dT%H:%M:%S.000Z

Best,

Fernando Vizcaino

[CharlieS]

Use this string instead:

%Y-%m-%dT%H:%M:%S

This tool works like RegEx and you can just enter the character "T". 

[KCAgentProvocateur]

thanks so much! i actually thought i had tried that but i must have made a mistake in it.

Working now 🙂

[BretCarr]

I had an issue with the .000Z part. I just left it off and it worked fine with the following structure from string to date format:

yyyy-MM-ddThh:mm:ss