Convert String to Date

[itahir04]

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 solution]

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,

[itahir04]

Hi Thableau,

Thanks for this, I was looking for an eaxample but this is a good reference table.

Regards,

Rana

[Thableaus · Accepted solution]

@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 solution]

Hi Thableaus,

Thanks for the solution.

Regards,

Rana