Date diff

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Wed, 18 Oct 2000 17:49:05 GMT
Message-ID: <39ede276.1052671109@news.alt.net>

I'd like to have a query return the amount of days SYSDate id before the date field in a table, excluding the year.

Table

1 2/27/1998
2 2/28/1999
3 2/29/2000
4 3/01/2001
5 3/02/2001

Imagine today is 2/26/2001

The return should be

Query

1 1
2 2
3 3
4 3
5 4

I'm not that concerned about Feb 29. I'd like like to take it into consideration. My main concern is the date difference itself.

Brian Received on Wed Oct 18 2000 - 12:49:05 CDT