Problem with getting records between two dates
Posted 04 June 2003 - 10:30 PM
DATE_FORMAT(picked_up_date,\'%D %M, %Y\' pickedUp_date
(picked_up_date >=1/3/2002 and picked_up_date<=6/3/2003)
I am trying to get al the records between 1/3/2002 and 6/3/2003. But this query is giving me nothing and if I change the \'and\' to \'or\' then it gives me all the records..
any help !!!!!
Posted 04 June 2003 - 10:58 PM
Posted 05 June 2003 - 03:54 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users