Convert System Date to mmddyyyy format

Question

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!

DavidKangni · Accepted Answer

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

DebTr · Answer

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=formatdate Thanks,Deb

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded