Calculating the days between 2 dates

  • Thread starter Thread starter jfriend
  • Start date Start date
J

jfriend

I want to track how many days have elapsed between the
date in the "started" field and today... in a field I'll
call "count".

For example... if the started field says 8/1/03 the count
field would say 27 (on the 27th) 28 (on the 28th) and so
on.

Thanks!!
 
Datediff will calculate the difference between the two dates that you
provide as parameters, to achieve the "running" calculation then you will
provide the parameters everytime you require to determine the difference
(every day?).

Obviously you will need a trigger that performs that request, which I am
assuming will be from within Outlook. When that trigger fires then you will
either display the date calculation, or update the Outlook field that you
require to see updated.

If you provide some indication on what you wish to achieve beyond just
comparing dates then I can be more specific

--
Regards
Graeme
=====================================
Websetters - home of the WS:Outlook AddIn
the only limits are those of vision...
www.websetters.co.uk
=====================================
 
Back
Top