Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Re: DAY() Formula Not Working For Date Lookup Field

489 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1

Hi @Peter_Midgley - yes, getting the same:

Screenshot 2019-12-18 at 21.40.45

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.