I am developing one application which requires me to compare date.The dataabse being MS access 2003.
When i execute the query in c# it does not show any record ,the date although matches with the date in database.
Where is the problem ?
The quey executed is
select * from finetable where fine_date=#1/9/2008 6:46:36 PM#
The record which matches it being
finetable (table name)
serial_no fine_date reg_no fine_place fine_code
3 1/9/2008 6:44:55 PM 125 india 123A
Why it is not showing ??
Maybe coz the time is diff. But I want to compare dates only.
Please help me !
80 in the topic name is a typo