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

Jeens
Community profile Jeens Level 1
Job title here
Location here
2 BADGES
Level 1

Level 1

Learn more
Joined the community 02-07-2021 3:15:42 PM
Offline
Top badges earned by Jeens
Customize the badges you want to showcase on your profile
Re: Convert System Date to mmddyyyy format
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
- Adobe Campaign Standard
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.

Views

67

Likes

0

Replies

0