mynetdude - profile

mynetdude · Jul 14, 2016

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

mynetdude · Jul 14, 2016

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

mynetdude · Jul 10, 2016

oh that’s an easy fix… just change the order! :grinning_face_with_big_eyes: Thanks again for your trouble :grinning_face_with_smiling_eyes:

mynetdude · Jul 09, 2016

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

mynetdude · Jul 09, 2016

I’ll send you a link to a screenshot and show you what the code does :slightly_smiling_face: (better than copy/paste)

mynetdude · Jul 09, 2016

wished I knew programming a bit better; but I’m having trouble with - being there and now its showing a minute off

User Statistics

User Activity

Using formulas for dates in a couple of different ways

Re: Days between dates

Re: Formula; Time worked?

Re: Formula; Time worked?

Re: Formula; Time worked?

Re: Formula; Time worked?