Member Avatar for pardeep3dec

Hi friends,
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

  • 2 Contributors
  • 1 Reply
  • 72 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

you need to format the date before passing that to database for processing.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.