Date filter

  • Thread starter Thread starter Waheeda Ali
  • Start date Start date
W

Waheeda Ali

I am running an apend query in access 2003 to analyze data from an outside
database. I am converting a non date string to date value with the following
expression in my sales date field in the query.
DateValue(Format([datestring],"@@@@/@@/@@"))

It is working fine, now I want to filter the dates and only wants records
after 12/31/2002. I had to leave the field type to "TEXT" in order for this
expression to work. Now I can't figure out how I should add the filter.
Can someone help.
 
Waheeda said:
I am running an apend query in access 2003 to analyze data from an outside
database. I am converting a non date string to date value with the following
expression in my sales date field in the query.
DateValue(Format([datestring],"@@@@/@@/@@"))

It is working fine, now I want to filter the dates and only wants records
after 12/31/2002. I had to leave the field type to "TEXT" in order for this
expression to work. Now I can't figure out how I should add the filter.
Click to expand...


Use your conversion expression in a blank column to create a
calculated field. Uncheck the Show box and set the new
field's criteria in the usual way.
 
Gosh, it was so simple. Thanks for your help.

Marshall Barton said:
Waheeda said:
I am running an apend query in access 2003 to analyze data from an outside
database. I am converting a non date string to date value with the following
expression in my sales date field in the query.
DateValue(Format([datestring],"@@@@/@@/@@"))

It is working fine, now I want to filter the dates and only wants records
after 12/31/2002. I had to leave the field type to "TEXT" in order for this
expression to work. Now I can't figure out how I should add the filter.
Click to expand...


Use your conversion expression in a blank column to create a
calculated field. Uncheck the Show box and set the new
field's criteria in the usual way.
Click to expand...
 
Back
Top