Converting Date to number of Days

[striker]

I've searched the archives and I can't find any info on converting a given date ie 29/07/03 to a number of days.

What I want to do is check overdue tasks and group them in less than 30 days overdue, 30 to 60 days overdue and greater than 60 days overdue. I don't want the aggro of putting the date criteria in everytime so all I have to do is click a button and hey presto.


Thanks for your help oh and by the way i'm using access97.


Cheers

Steve

 

[dcx693]

Check out this thread: Age bracket query The thread discusses showing results by person's age, but it's easy enough to adapt to dates.

You can use the DateSerial and DateAdd functions to get the date x number of days ahead/behind.