
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 29, 2023 11:00 AM
I have a formula that works as is today, but I'm trying to add a condition to it and it keeps erroring out? Was hoping to get some extra eyes on it?
What we're doing today is taking 3 different date fields, convert them to a #, and then display the max of the 3 fields. This might be a weird way to get where we need to go, but it has worked for us. All the "correct" fields are date fields in our base.
Formula today:
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 29, 2023 04:47 PM
Looks like there's an extra ")" in there.
{New Value)} -> {New Value}
IF({New Value}, VALUE(DATETIME_FORMAT({New Value},'YYYYMMDD')))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 29, 2023 04:47 PM
Looks like there's an extra ")" in there.
{New Value)} -> {New Value}
IF({New Value}, VALUE(DATETIME_FORMAT({New Value},'YYYYMMDD')))
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 31, 2023 04:28 AM
Where are you writing this syntax in airtable. I am not able to do such type of things @Sho

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 31, 2023 01:23 PM
Thank you!
