future date value

[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

 

[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

 

[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

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

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