Sep 04, 2020 01:32 PM
Driving me crazy … why doesn’t this work? PROMOEND is a date field.
DATETIME_DIFF(TODAY(),PROMOEND,’months’)
Sep 04, 2020 01:37 PM
Make sure that your quotes are straight quotes instead of curly quotes. Airtable’s formula engine doesn’t recognize anything except for straight quotes.
Sep 04, 2020 01:41 PM
Hmm, well aren’t these straight quotes … symbol under double quote on my keyboard.
DATETIME_DIFF(TODAY(),PROMOEND,’months’)
Sep 04, 2020 02:37 PM
@J_Allen, the difference is that those curly quotes are rich-text, while the straight ones are plain-text.
Big pain in the bottom, but avoided by copy/pasting from a plain-text editor like notepad. If you put it in microsoft word or something like that, the straight quotes get converted to those curly quotes.
Sep 04, 2020 03:00 PM
Thanks Kris. So I used my Mac vs iPad (the Airtable app) and though the same exact key on the keyboard was used, that worked. Perhaps a nuanced difference in iOS Safari > Airtable.com vs. macOS > Airtable app … but one would expect it would have worked.