Calculate Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to calaulate the dates? ie. we have a 2005 dodge truck since 05/01/2006,
today's date 10/13/2006, like to know many days old?
 
Carol,

I'm assuming you're doing this in a query grid?
Try: HowOldAmI: Date()-[PurchaseDateField]
 
How to calaulate the dates? ie. we have a 2005 dodge truck since 05/01/2006,
today's date 10/13/2006, like to know many days old?

On a form or in a report:
=DateDiff("d",[PurchaseDate],Date())
 
Back
Top