PDA

View Full Version : Return results from before todays date.


lux
04-22-2006, 03:18 PM
I wish to create to recordsets;

One which returns all rows from before today’s date and a second that returns any results from today.

Any help would be much appreciated.

lux
04-22-2006, 03:19 PM
Sorry, im using php, forgot to say!

davidj
04-24-2006, 07:23 AM
select * from table where date_field < curdate()

select * from table where date_field = curdate()

lux
04-25-2006, 01:31 PM
cool cool

thanks for the responce