Datetimediff producing weird values

[Ariana_Garbers]

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.

[kuovonne · Accepted solution]

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