My problem is i am unable to find out records within a specified date. I am describing my programme detail
i have a column in ms access
table name travel
column naem doj
data type date/time
format short date ' dd/mm/yyyy
in visual basic i took two datepicker named doj1 and doj2 with format "dd/mm/yyyy"
but when i run following query then it shows wrong records.
select * from travel where doj between #"& doj1.value &"# AND #& doj2.value &"#;
i also used
select * from travel where doj >= #"& doj1.value &"# AND doj <= #& doj2.value &"#;
but result same .
I used julian code but it is not working for the month jan and feb