Skip to main content

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

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')


)

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

Reply


Terms & Conditions