Date Formulas in Contact Forms

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

How do I create a formula field that has as its value the
time difference between today's date and a date as
recorded in another field?
 
DateDiff("h",[OtherField],Now)

Look up DateDiff in Help to see what other time intervals you can measure.
The formula above measures the difference in hours.
 
Thank-you Sue. Big Help.
-----Original Message-----
DateDiff("h",[OtherField],Now)

Look up DateDiff in Help to see what other time intervals you can measure.
The formula above measures the difference in hours.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



How do I create a formula field that has as its value the
time difference between today's date and a date as
recorded in another field?
Click to expand...


.
Click to expand...
 
Back
Top