Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Dec 16, 2019 08:57 PM
I have a table with a Lookup field that returns a date from a linked record. I’ve confirmed that the Lookup field contains valid date values. The MONTH() and YEAR() formulas work as expected with the Lookup field. But the DAY() formula only returns an “ERROR!” message for each record. Any suggestions?
Dec 18, 2019 01:43 PM
Hi @Peter_Midgley - yes, getting the same:
This feels like a bug, tbh. Each of these formulas is parsing the lookup date for a different element, so no idea why one won’t work and the others do. Might be worth raising with Airtable support.
JB