This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I have a date field and need to create a formula that compares the data in this date field to a hard coded date. IF (date field > 1/21/2019, x, y) as an example. How do I enter 1/21/2019 in a formula? I know there are different ways to do that in Exc...
Thank you for your suggestions. Airtable Support did get back to me and it was fairly simple. I just needed to put the hard coded date in single quotes. For my request, the resolve was IF(IS_AFTER({Date Field}, ‘1/21/19’),1,0). It worked!
