Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: DATETIME_DIFF not working

1548 3
cancel
Showing results for 
Search instead for 
Did you mean: 
J_Allen
6 - Interface Innovator
6 - Interface Innovator

Driving me crazy … why doesn’t this work? PROMOEND is a date field.

DATETIME_DIFF(TODAY(),PROMOEND,’months’)

4 Replies 4

Make sure that your quotes are straight quotes instead of curly quotes. Airtable’s formula engine doesn’t recognize anything except for straight quotes.

Hmm, well aren’t these straight quotes … symbol under double quote on my keyboard.

DATETIME_DIFF(TODAY(),PROMOEND,’months’)

Kris
6 - Interface Innovator
6 - Interface Innovator

@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.

J_Allen
6 - Interface Innovator
6 - Interface Innovator

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.