Re: Datetime_parse error

168 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

This is probably easy, but I’m using DATETIME_PARSE so that a field being called up can be converted to date, but sometimes those fields that are called up don’t have dates, so it returns an error where there is no date to convert, how do I make it return a blank?

1 Reply 1

for now i’ve been able to solve this by doing this, but it’s not ideal for me because I need to do a formula to create Custom Field 1 before I can then use another formula to get rid of the error. looking to simplify somehow.

Formula 1 defines Custom Field 1 by grabbing multiple fields based on conditions

Formula 2:
IF({Custom Field 1}=BLANK(),BLANK(),DATETIME_PARSE({Custom Field 1}))