Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Datetime_parse error

Topic Labels: Formulas
361 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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