Convert System Date to mmddyyyy format

Avatar

Avatar

alik98709228

Avatar

alik98709228

alik98709228

25-03-2021

Hello,

 

I am trying to convert system date to in this format: mmddyyyy

So for today which is March 25th, 2021, it should show as 03252021

 

I am using the following formula:

 
Month(GetDate())+'/'+Day(GetDate())+'/'+Year(GetDate())
 
It worked but the results are coming up in format "3/245/2021". Is there a way, I can get the 2 digits for the month without having the "/". For instance. for today, the output should be: 0325202
 
Any ideas?
 
Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

DavidKangni

MVP

Avatar

DavidKangni

MVP

DavidKangni
MVP

26-03-2021

Hi @alik98709228 

 

Please use this 

Iif(Month(GetDate())>9, ToString(Month(GetDate())), '0'+ToString(Month(GetDate())))+Iif(Day(GetDate())>9, ToString(Day(GetDate())), '0'+ToString(Day(GetDate())))+ToString(Year(GetDate()))

 

Also make sure to post in ACS forum instead of ACC.

 

Thanks,

David

Answers (1)

Answers (1)

Avatar

Avatar

Deb007

Avatar

Deb007

Deb007

26-03-2021

Hi @alik98709228 ,

Hope this will work.

 

var a = formatDate(new Date(), "%2M%2D%4Y");
logInfo(a);

 

You can refer to the following for more details.

https://docs.adobe.com/content/help/en/campaign-classic/technicalresources/api/f-formatDate.html?hl=...

 

Thanks,

Deb