Convert Salesforce Date Time string to Alteryx Date time

[Madhu-Navuluri]

Hi All,

I am new to Alteryx and from a salesforce CRM background.

in salesforce the date-time stores as "YYYY-MM-DDTHH:MM:SS"

example: 2021-03-28T17:30:20

Can someone please help me with the conversion?

Thanks,

Madhu

[AngelosPachis · Accepted solution]

Hey @Madhu-Navuluri ,

I attached a workflow with two examples of how you can go about converting those datetime fields, one using a formula tool and the other using a Datetime tool.

Hopefully this is what you are after

Cheers,

Angelos

[Madhu-Navuluri]

Hi Angelos,

Thank you so much for the answer, it works perfectly for my issue. I have marked it as "Accepted Solution"

Thanks,

Madhu

[AngelosPachis]

Thank you @Madhu-Navuluri , happy that works for you 🙂