I Ivor Williams Jan 7, 2004 #1 How do I write an expression in a query to return the number of days between a specified date and the current date? TIA, Ivor
How do I write an expression in a query to return the number of days between a specified date and the current date? TIA, Ivor
J Jim Pavek Jan 7, 2004 #2 Ivor, Try this: datediff("D", #1/1/2004#, Now) This should return 6. You can also use M for how many months away from current date or Y for years. Jim Pavek Fort Collins CO www.squarei.com
Ivor, Try this: datediff("D", #1/1/2004#, Now) This should return 6. You can also use M for how many months away from current date or Y for years. Jim Pavek Fort Collins CO www.squarei.com
