Hi GUIDO22,
Thank you very much for your reply. I have solved that issue by using the following query,
string sdatecheck = "select * from leavemaster_table where (from_date <= #" + this.Txt_Fromdate.Text + "# and to_date >= #" + this.Txt_Fromdate.Text + "#) or (from_date <= #" +...
Hi ,
I am developing an application in c#.net with Ms-Access as the database. I need to findout whether a date entered by the user falls between the 'from_date' & 'to_date' fields in a table.
Ex:
sno from date To date
1 08-jul-09 09-jul-09
2 14-jul-09 16-jul-09
3...