Number of days in date range

I

Ivor Williams

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

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
 
Top