Converting Date

[nirvapatel1998]

Hi All. 

I have  a date format 9-Aug-22 and I want to convert it to 20220809. Any suggestions on how I can get it? 

Thank you in advance.

[DataNath · Accepted solution]

Hey @nirvapatel1998, this should do the trick. You first parse out the date from your incoming string, before wrapping that in the DateTimeFormat() function to get your desired format:

DateTimeFormat(DateTimeParse([Incoming Date],'%d-%b-%y'),'%Y%m%d')

[DavidSkaife · Accepted solution]

Hi @nirvapatel1998 

Assuming your date is in string format:

DateTimeFormat(DateTimeParse([Date],'%d-%h-%y'),'%Y%m%d')

[DavidSkaife]

@DataNathalmost snap :)

[nirvapatel1998]

Thank you DataNath

[nirvapatel1998]

Thank you David