Hi all,

I am trying to extract records which have a birthdate within 30 days of CURRENT DATE. I am having all sorts of problems. I need to extract those records with the same month as the current month, but whos day value is equal or greater to the current day, then I need to extract those records that are next month but still within 30 days of the curretn day. Finally I need it to wrap correctly round months and year ends!

It is driving me a little nuts as I cant see a way to do it!

thanks
Rolf