This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
First I need to know what the formula structure should be if I want to know how many days between two dates (I want to know how long it took for XX product to be depleted since the date of use vs when I first purchased it. So for example
I buy somet...
Old thread; but hey the topic still has merit
I tried this formula DATETIME_DIFF([date1], [date2], ‘units’) and I get an error message so tried this:
DATETIME_DIFF([Date Depleted], [Date Purchased, ‘days’) and so I am assuming I am doing it incorrect...
ok here it is
you can see its from 11am to 12pm it is 1hr and 1 min it should be 1hr 0 min
I don’t really need the seconds though but I’ll just leave it for simplicity
https://cloudup.com/c6Ch9ZtoGE3/f <— that’s the screenshot
