fetch records of today only

Question

Hi members,

I am working on C# Windows Application with Access database.

I want a select query that fetches all the records of today only. I know how to use the date time picker and text box but in this case I want to use the system date automatically.

I have tried the below query...

Select BillSrNo,BillPartyName,BillAmtPaid From Billings Where BillDate=" + DateTime.Now.ToShortDateString(), MyConnAcc);

...but it's not working and even not throwing any exception. I have also tried with DateTime.Today etc. but same result.

 

Thanks

 

Mayank Jani