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?
Page 1 / 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}))
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.