future date value


G

Guest

I am trying to filter dates based on the DateAdd field in my query. It will
not allow me to use specific criteria in the query under the DateAdd field. I
can filter if I use enter the date in the expression such as Between
#04/01/2005# And #05/01/2007# in the DateAdd field. I want to filter the
criteria based on the dates I enter in a form. I am using this as my
expression.

Between [Forms]![Employee Information]![Start Date] And [Forms]![Employee
Information]![End Date]

This expression works fine in all fields execpt the dateadd field
 
Ad

Advertisements

G

Guest

Do you have a Field called DateAdd, or you mean that you are using the
DateAdd function?

If it's a field name, I recomand changing it, because it's a build in
function name in Access.
If the you ,ean using the function, can you post the full SQL?
But before that, check if the DateAdd actually return values without the
criteria
 
Ad

Advertisements

G

Guest

Actually I got it figured out I had to use a CDate() expression so that it
would recognize the information as a date rather than just data. Thanks.

D

Ofer Cohen said:
Do you have a Field called DateAdd, or you mean that you are using the
DateAdd function?

If it's a field name, I recomand changing it, because it's a build in
function name in Access.
If the you ,ean using the function, can you post the full SQL?
But before that, check if the DateAdd actually return values without the
criteria


--
Good Luck
BS"D


Dendalee said:
I am trying to filter dates based on the DateAdd field in my query. It will
not allow me to use specific criteria in the query under the DateAdd field. I
can filter if I use enter the date in the expression such as Between
#04/01/2005# And #05/01/2007# in the DateAdd field. I want to filter the
criteria based on the dates I enter in a form. I am using this as my
expression.

Between [Forms]![Employee Information]![Start Date] And [Forms]![Employee
Information]![End Date]

This expression works fine in all fields execpt the dateadd field
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top