Dev Space

Customize & extend the power of Alteryx. SDKs, APIs, custom tools, and more!
SOLVED

Date Time Conversion

AS
8 - Asteroid

Hi,

I'm getting trouble using conversion of date time activity. I wanted to change the format and not getting proper result. Please help. Attaching screenshot

 

Thanks in Advance 

5 REPLIES 5
atcodedog05
20 - Arcturus

Hi @AS 

 

You configure like below. It should work.

 

atcodedog05_0-1628692020133.png

 

Hope this helps : )

AS
8 - Asteroid

Hi @atcodedog05 , I tried your suggestion. It worked putting dd-MM-yyyy in custum changed the date as yyyy-MM-dd but how this worked. I couldn't understand. Could you elaborate for me. 

atcodedog05
20 - Arcturus

Hi @AS 

 

Its trimming out 21 from 31-05-2021 and converting to date to fit the format. Seems like yy and yyyy are bot acceptable format.

 

Hope this helps : )

AS
8 - Asteroid

hi @atcodedog05... okay understood.  Thank you so much.. 🙂

atcodedog05
20 - Arcturus

Happy to help : ) @AS 

Cheers and have a nice day!