Date format

[DiyaR]

Hi, I am trying to change input source from string to date and then change to date format. 

Input source: 4/21/2021 (string)

I used date conversion to change string to Date.. but it gives me Null.

once field is identified as date, I want the output to read as "20210421", so I used 

DateTimeFormat([account open date],'%Y%m%d')

Since my first step is Null, this is not working. Can someone please help 🙂

Thank you

[MarqueeCrew · Accepted solution]

@DiyaR ,

 to save input as a date:

datetimeparse([input],"%m/%d/%Y")

 to Output from a date:

 datetimeformat([date],"%Y%m%d")

 To simply change in one step:

 datetimeformat(datetimeparse([input],"%m/%d/%Y"),"%Y%m%d")

 cheers,

 mark

[DiyaR]

Right on! 

Liked the one step. Thank you so much !

[MarqueeCrew]

@DiyaR  You're welcome!

happy Inspire

[amruthas2]

Hi @DiyaR 

Link for your future reference

DateTime Functions | Alteryx Help