Loading

when i check partiuclar date using query in msaccess Db

narasiman rao

MS Access Data Base;

when i run the below query;

select * from Tb_SCh_TIme_Table

Sch_Date Session Course Faculty_Code
2/11/2013 1 ARPA BAB
2/12/2013 1 CHEMCO BSR
2/13/2013 3 CL2 CJJ

when i run the Below query

select * from Tb_SCh_TIme_Table where Sch_Date = 2/11/2013

The output is not coming why?

what is the problem in my above query?

Please help me.

Regards,

Rao

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak13y ago
If datatype is Text then use

str = "select * from Tb_SCh_TIme_Table where Sch_Date = '2/11/2013'";

If datatype is datetime then use

str = "select * from Tb_SCh_TIme_Table where Sch_Date = #2/11/2013#";

Thanks
0