Datetime_parse error

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?

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.