G Guest Oct 14, 2006 #1 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?
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?
G Gina Whipp Oct 14, 2006 #2 Carol, I'm assuming you're doing this in a query grid? Try: HowOldAmI: Date()-[PurchaseDateField]
F fredg Oct 14, 2006 #3 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? Click to expand... On a form or in a report: =DateDiff("d",[PurchaseDate],Date())
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? Click to expand... On a form or in a report: =DateDiff("d",[PurchaseDate],Date())