DATETIMEFORMAT Function

[SaâdEnnassiri]

Hello, 

I'm trying to convert these dates under this format Aug 12, 2019 to sample alteryx format.

When I use the function DATETIMEPARSE or DATETIME tool , the results are OK but when I use the DATETIMEFORMAT function , I'm getting only NULLS.

Can you please advise?

Thx

[JosephSerpis · Accepted solution]

Hi @SaâdEnnassiri datetimeformat is for converting date data fields into a string data type hence why you are getting nulls at present. I've amended your workflow to showcase how to do this.

[SaâdEnnassiri]

Thanks a lot Sir. much appreciated.