Convert System Date to mmddyyyy format

[#1]

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!

[ramon_bisswanger · Accepted solution]

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

[ramon_bisswanger · Accepted solution]

Or you can simplify the formula slightly:

Right('0'+ToString(Month(GetDate())), 2) + Right('0'+ToString(Day(GetDate())),2) + ToString(Year(GetDate()))

[Jeens · Accepted solution]

@davidkangini

[Jeens · Accepted solution]

Hi

[Jeens · Accepted solution]

Am trying to pass an expiration date through enrichment by concatenating by taking 2variable[variable1||variable2], but after that I am getting the date for

[Jeens · Accepted solution]

Am trying to pass an expiration date through enrichment by concatenating by taking 2variable[variable1||variable2], but after that I am getting the date format as yyyy-mm-dd, could some one please help me to get the date format as variable_field=ddmmyyyy,

[#8]

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