I want to select from table where date with between 

but problem is that in database there is not datetime column there is separated dateTime year, month and day

does it possible to create new variable inside stored procedure something like that? 

checkin = new DateTime(year, month, day)

this year month and day are columns in datatable