Help

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

Datetimediff producing weird values

Topic Labels: Formulas
Solved
Jump to Solution
133 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I’ve made this datetimediff formula with two lookup values that are both formatted in the way of date with the same time zones. Lots of the values are accurate, but some values are very off… I’ve attached screenshots here for reference. The most_recent_sold_date is a lookup from a rollup value, but I would think it would still work in the formula.

image
image

1 Solution

Accepted Solutions

Welcome to the Airtable community!

Your screen shot of the field values shows the field {date_processed} but your screen shot of the formula shows the field {UPLOADED_AT}.

See Solution in Thread

1 Reply 1

Welcome to the Airtable community!

Your screen shot of the field values shows the field {date_processed} but your screen shot of the formula shows the field {UPLOADED_AT}.