Date Format Function in Adobe Campaign Standard | Community
Skip to main content
A
Anilr1717
July 29, 2020

Date Format Function in Adobe Campaign Standard

  • July 29, 2020
  • 2 replies
  • 6718 views

Hi All,

 

Putting some logic for Date Format function in Adobe Campaign Standard.

 

 

ToDate(LPad(ToString(Month(GetDate())),2 ,'0' )+'/'+LPad(ToString(Day(GetDate())),2 ,'0' )+'/'+ ToString(Year(GetDate()))) ----MM/DD/YYYY (07/29/2020)

 

Regards,

Anil

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

M
Madhuri_d
August 4, 2021

Hi All,

I need to display date as '27AUG2021HH:MM:SS'. Can you help?

C
Cogs
September 3, 2021

Thanks Anil. 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 0/0/. Is there anyway to overcome this. I have tried various functions and nothing gets parsed.

Terms & ConditionsAccessibility statement

Loading footer...