Re: sql distress

Hi Kevin You can do it this way ... ##---------------------------------------------------------------## SELECT * FROM table1 WHERE MONTH(date_field) BETWEEN "01" AND "06" AND DAY(date_field) BETWEEN "01" AND "20" ##---------------------------------------------------------------## This one will sure work... BTW< I tried one another query which didnt work... SELECT * FROM table1 WHERE EXTEND(date_field, MONTH TO DAY) BETWEEN EXTEND("01/01/1999", MONTH TO DAY) AND EXTEND("20/06/1999", MONTH TO DAY) another one also didnt worked... SELECT * FROM table1 WHERE EXTEND(date_field, MONTH TO DAY) BETWEEN ("01/01/1999") AND ("20/06/1999") BTW, We Indian use DMY Format for dates.. TIA, and Good Luck to Kevin for his query Nayan Jain @TataInfotech.Com - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - "You don't love a woman because she is beautiful, but she is beautiful because you love her." -Anon On Fri, 11 Jun 1999 Kevin_Burdish@timeinc.com wrote: > > Hey Gang: > My mind has a cramp, hoping somebody can help! > I want to query a date field for all rows between 02/03 and 03/04 in > any year. I've tried some stuff, but can't seem to get it yet. Any > help would be greatly appreciated! > Thanks, > Kevin > > >