Re: Date comparisions...

2001-05-02 Thread Rick Pasotto
On Wed, May 02, 2001 at 04:00:17PM +0100, Roo wrote: > Hi all, > > I was recently attempting what I thought would be an easy search. I > wanted to return all records with a birthdate (a DATE column) 'within' > 30 days of the current date. > > The birthdate is stored as a -MM-DD, I have been

Re: Date comparisions...

2001-05-02 Thread Rolf Hopkins
There are a whole heap of very useful date functions in chapter 7 of the manual that will make all your problems disappear. - Original Message - From: "Roo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 02, 2001 23:00 Subject: Date comparisions... > Hi all, > > I was