Convert String to Date

Question

Hi Community:

How do I convert this Date field with string data type to a desired date format:

Current Date field example : 2020-05-29T10:26:10.5370000

Desired output example (need this format) : 8/30/2016 4:59:00 PM

Thanks,

itahir04

Thableaus · Accepted Answer

Hi @itahir04

I strongly recommend you to use this table as a reference for any date conversions:

https://help.alteryx.com/current/designer/datetime-functions

You also have the functions you can use to parse and format dates.

Cheers,

Thableaus · Accepted Answer

@itahir04

Here's a solution

I'd replace the T or Z characters, convert to an Alteryx datetime format, and then format the date according to what you want.

I'm attaching the workflow.

Cheers,

itahir04 · Accepted Answer

Hi Thableaus,

Thanks for the solution.

Regards,

Rana