Expand my Community achievements bar.

Date Format Function in Adobe Campaign Standard

Avatar

Level 1

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

2 Replies

Avatar

Level 1

Hi All,

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

Avatar

Level 2

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.