Re: record not displaying between particular date

Can you post your actual code, and DB schema?

"bitu" <bitu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FEFA6F31-55A7-4857-B09C-294E5236FC05@xxxxxxxxxxxxxxxx
it is 20th june 2006 and 20th july 2006.it was by mistake written.

thank u

arpana

"Lance Wynn" wrote:

"20th june 2006 and 20th june 2006"

Is this a typo? Did you mean 20th June, and 20th July? Or is this how it
is written in your code?


"bitu" <bitu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:637C47A4-8717-48A3-9EDC-95B530EACC0D@xxxxxxxxxxxxxxxx
hello Ralph,
thank u very much for u r reply & helping me to solve the problem.

i tried my best in using delimiters and format() function.but again the
same
problem. u take any month always there is a problem between 3rd and 9th
date.it won't select the record when i am entering the date in between
these
two date.

eg-3rd july 2006. it should display cancer because it comes between 20th
june 2006 and 20th june 2006.

but the same error comes that eof or bof is true or current record is
deleted. this means it is not considering the date between 3rd to 9th. u
just
try and see.

waiting for ur reply.
thank u,

arpana






.

Loading