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
Solved! Go to 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
Right on!
Liked the one step. Thank you so much !
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |