Since
VBScript has a built-in DateDiff function, you could use:
DateDiff("d", [Created], Now())
--
Sue Mosher
Author of
"Teach Yourself Microsoft Outlook 2000 Programming in 24 Hours"
"Microsoft Outlook 2000 E-mail and Fax Guide"
Outlook and Exchange solutions at http://www.slipstick.com
Quote:
> I have a custom contact form for my clients.
> Everytime a new lead (Prospect) inquire about our product brochure,
> I create a NEW contact form. On the form I have a standard field called
> *Created* (It basically stamps the date and time when the NEW form was
> created.
> Now I created a NEW FIELD That I called DAYS and what I'd like to
accomplish
> is that every time that I start Outlook in the morning I want to see how
> many days have past since *THOSE* prospects requested a brochure.
> I thought it was simple but apparently it's not.
> The manner I went about doing this is in the DAYS field property I wrote
the
> formula DateDif=("d",[Created]-Now()) ...Not only it didn't work but it
> gives me once in awhile strange calculations.
> Any suggestions?
> Joe
Keep track of day count