i cannot filter in the correct dates

  • Thread starter Thread starter Lee Taylor-Vaughan
  • Start date Start date
L

Lee Taylor-Vaughan

Hi.

I am trying to use a between expression to get all the
dates between a certain range, but i am getting date that
are for a totally different year.

I am typing in the dates with the year 2003 and I am
getting all other dates outside of this range.

I have tried using a format(field, "short date"), and
CDate, but no luck. using Cdate i get some errors that
say invalid use of null--i guess because some of the
fields ae empty.

Please help

Lee
 
Hi.

I am trying to use a between expression to get all the
dates between a certain range, but i am getting date that
are for a totally different year.
Click to expand...

Is this a Date/Time field, or a Text field, or a formatted expression?
Please post the actual SQL or filter expression that you're using.
 
How do you actually get the data entered to populate the
table with a range of dates ? i.e. you say you have used
a between expression. I am also trying to get this to
work in my database.

Regards
Samina
 
How do you actually get the data entered to populate the
table with a range of dates ? i.e. you say you have used
a between expression. I am also trying to get this to
work in my database.
Click to expand...

My impression was that Lee has a single date field and is using a
range criterion such as

BETWEEN [Enter start date:] AND [Enter end date:]

If you want to store a range of dates in a table you will need to
store TWO fields, the start and end of the range. Searching this can
be a bit complicated since you may need to check for overlapping
ranges.
 
Back
Top