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
=====================================
"jfriend" <(E-Mail Removed)> wrote in message
news:03c701c36ce5$7afe90c0$(E-Mail Removed)...
> I've never programmed Outlook. I googled datediff and
> I'm lost. It looks like datediff will only figure
> between 2 fixed dates I want to have it post a "running"
> calulation (one that changes every day)
>
> Any ideas? Thanks!
>
> >-----Original Message-----
> >Take a look at the DateDiff() function.
> >--
> >Sue Mosher, Outlook MVP
> >Outlook and Exchange solutions at
> http://www.slipstick.com
> >Author of
> > Microsoft Outlook Programming: Jumpstart
> > for Administrators, Power Users, and Developers
> > http://www.outlookcode.com/jumpstart.aspx
> >
> >
> >"jfriend" <(E-Mail Removed)> wrote in
> message news:030d01c36cba$d0dd8080$(E-Mail Removed)...
> >> 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!!
> >.
> >
Similar Threads
