Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Date Format Function in Adobe Campaign Standard

Avatar

Avatar
Give Back
Level 1
Anilr1717
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Shape 1
View profile

Avatar
Give Back
Level 1
Anilr1717
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Shape 1
View profile
Anilr1717
Level 1

29-07-2020

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 Comments

Avatar

Avatar
Level 1
Madhuri_d
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
Madhuri_d
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
Madhuri_d
Level 1

03-08-2021

Hi All,

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

Avatar

Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile

Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
Level 2

03-09-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.