Date Format Function in Adobe Campaign Standard

[#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]

Hi All,

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

[#3]

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.