Convert System Date to mmddyyyy format | Community
Skip to main content
alik98709228
alik98709228
Level 2
March 26, 2021
Solved

Convert System Date to mmddyyyy format

  • March 26, 2021
  • 2 replies
  • 3060 views

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!
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by DavidKangni

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

2 replies

D
DebTr
Level 6
March 26, 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=formatdate

 

Thanks,

Deb

DavidKangni
Community Advisor
DavidKangniCommunity AdvisorAccepted solution
Community Advisor
March 26, 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

David Kangni
    C
    Cogs
    Level 2
    September 3, 2021

    Thanks David. That works for GetDate() but what happens if you apply the formula to a field in which the date is only present some of the time? When the date is not present the value output into the field is "00". Is there anyway to overcome this. I have tried various functions, e.g.IsEmptyString(datefield) - with and without ToString(datefield) - Iif(datefield IS NULL, Iif(Length (datefield) = 0 , etc. etc,. and nothing gets parsed.

    Terms & ConditionsAccessibility statement

    Loading footer...