
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 13, 2023 01:47 AM
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?
Solved! Go to Solution.
1 Solution
Accepted Solutions

Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 13, 2023 03:49 AM
Reply
2 Replies 2

Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 13, 2023 03:49 AM
How about this?
IF({Start Date},DATETIME_FORMAT({Start Date},'ddd, MMM, DD'))
Reply

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 13, 2023 03:54 AM
YES! That worked! The Airtable Community strikes again!
THANK YOU
