M Mich76 New member Local time Today, 18:07 Joined Mar 10, 2010 Messages 4 May 7, 2010 #1 How do I word a query to show how many days have elapsed, from the date an item has been logged. Thanks Michelle
How do I word a query to show how many days have elapsed, from the date an item has been logged. Thanks Michelle
stopher AWF VIP Local time Today, 18:07 Joined Feb 1, 2006 Messages 2,388 May 7, 2010 #2 You can use the following calculation in your query: DaysElapsed: DateDiff("d",[LoggedDate],Date()) Chris
You can use the following calculation in your query: DaysElapsed: DateDiff("d",[LoggedDate],Date()) Chris