Help

Adjust DateTime_Format for numerous Dates in One Formula

Topic Labels: Formulas
Solved
Jump to Solution
587 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Kristen_Edge
6 - Interface Innovator
6 - Interface Innovator

I created a formula field to merge three date fields into one. No record has more than one date, so I wanted them all to be in one place. However, when I used concatenate, the dates are very long, so I’m trying to use DateTime_Format for all three, but I keep getting Errors. I’ve tried looking this up and have tried different combinations, but no luck.

image

Here’s what it looked like originally before I tried formatting
image

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

You can’t format an empty cell, which is probably why you got errors. Try

IF(
   OR({SF - Conf Date}, {Survey Date}, {Event Date}),
   DATETIME_FORMAT(
      IF({SF - Conf Date}, {SF - Conf Date}, IF({Survey Date}, {Survey Date}, {Event Date})),
      "MM/DD/YYYY"
   )
)

Since you said only one date will matter, I used a series of cascading IF() statements to insert a date field if its filled in, otherwise it will check the other fields.

See Solution in Thread

1 Reply 1
Kamille_Parks
16 - Uranus
16 - Uranus

You can’t format an empty cell, which is probably why you got errors. Try

IF(
   OR({SF - Conf Date}, {Survey Date}, {Event Date}),
   DATETIME_FORMAT(
      IF({SF - Conf Date}, {SF - Conf Date}, IF({Survey Date}, {Survey Date}, {Event Date})),
      "MM/DD/YYYY"
   )
)

Since you said only one date will matter, I used a series of cascading IF() statements to insert a date field if its filled in, otherwise it will check the other fields.