Member Avatar for pardeep3dec

Hi friends,
my query not worked.
rc.open"select * from travel doj between #"& doj.text &"# AND #"& doj1.text &"#;
suppose
doj.text=01/09/2008
doj1.text=22/09/2008

but it shows july records also.

  • 5 Contributors
  • 4 Replies
  • 66 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by venkatramasamy
Member Avatar for guest11

give date value as

doj.text=09/01/2008
doj1.text=09/22/2008

i hope it will work try it

Member Avatar for debasisdas

you need to format the date properly before passin gthat to database for processing

Member Avatar for selvaganapathy

Hi, Are you forget WHERE Clause or typo mistake?

SQL = "SELECT * FROM travel WHERE doj BETWEEN #" & doj.text & "# AND #" & doj1.text  & "#;"
Member Avatar for venkatramasamy

HI,

You better to store the Taxtbox value in Date Variable,

Dim FrmDate as date
Dim ToDate as Date

FrmDate=doj.text
ToDate=doj1.text

SQL = "SELECT * FROM travel WHERE doj BETWEEN #" & FrmDate & "# AND #" & ToDate  & "#;

Hope this will help you,


With regards
Venkatramasamy SN

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.