My dataset format looks like this
EMPNAME FRMDATE TODATE
ANU 01-10-2012 01-20-2012
HARI 01-05-2012 02-05-2012
Now get input through a textbox as 01-17-2012
for a specific employee.
My question is: how to check whether the i/p date is between these two columns (FRMDATE,TODATE) in the dataset?
Try This