future date value

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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
Click to expand...
Click to expand...
 
Back
Top