Help

Extracting Time from Date Field - But how to avoid #ERROR if date field is blank?

Topic Labels: Formulas
Solved
Jump to Solution
1162 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Burke
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there,

I am using a formula field to pull the time stamp (and t-zone) from a Date and Time field. I am using this formula currently: DATETIME_FORMAT(SET_TIMEZONE({Day 1 - Start}, ‘America/Los_Angeles’), ‘h:mm a’). This works wonderfully, however, if the time and date field is blank (which, in my case, does happen) my time stamp field shows #ERROR. How can I add to this formula so it knows to leave the field blank if the date and time field is blank?

Would appreciate all and any help on this.

Daniel

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Wrap your formula in an IF function that tests if there is a value in the date/time field.

IF(
  {Day 1 - Start},
  DATETIME_FORMAT(SET_TIMEZONE({Day 1 - Start}, 'America/Los_Angeles'), 'h:mm a')
)

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

Wrap your formula in an IF function that tests if there is a value in the date/time field.

IF(
  {Day 1 - Start},
  DATETIME_FORMAT(SET_TIMEZONE({Day 1 - Start}, 'America/Los_Angeles'), 'h:mm a')
)

Thank you so much! This was exactly what I was looking for!

So appreciative!
Daniel