Help

Re: Datetimediff producing weird values

Solved
Jump to Solution
782 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Ariana_Garbers
4 - Data Explorer
4 - Data Explorer

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
kuovonne
18 - Pluto
18 - Pluto

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
kuovonne
18 - Pluto
18 - Pluto

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