Date filter

[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.

 

[Marshall Barton]

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.

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.

 

[Waheeda Ali]

Gosh, it was so simple. Thanks for your help.

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.

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.