Date Formulas in Contact Forms

[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?

 

[Sue Mosher [MVP-Outlook]]

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.

 

[Andrew]

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?

.