Help

DATETIME #Error return

Topic Labels: Formulas
Solved
Jump to Solution
429 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Melanie_Lemnios
5 - Automation Enthusiast
5 - Automation Enthusiast
 
I have a series of records that include a Start Date field that I want to incorporate into a larger 
CONCATENATE formula. 
 
However, some of the records do not yet have a date and the Start Date field is blank so my formula is returning an #ERROR.  I have tried adding an IF=BLANK statement to the formula (see example below) but that doesn't seem to be working either.
 
IF({Start Date}=BLANK(),(DATETIME_FORMAT({Start Date},'ddd, MMM, DD')
 
any suggestions on what to try next?
1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

How about this?

IF({Start Date},DATETIME_FORMAT({Start Date},'ddd, MMM, DD'))

 

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

How about this?

IF({Start Date},DATETIME_FORMAT({Start Date},'ddd, MMM, DD'))

 

Melanie_Lemnios
5 - Automation Enthusiast
5 - Automation Enthusiast

YES!  That worked!  The Airtable Community strikes again!

THANK YOU