date selection criteria

[Alla]

I am writing a query in Access2002. Dates in the dastabase
are a time/date stamp in encoded format. I convert
date/time stamp to standart date and time and format it as
short date. Then, in the same query I put a criteria to
search date <[End date], and wouldn't get anything in the
result. Query works fine if I put an actual date instead
of [end date]. It doesn't happen with >[end date].
I've never ran into a problem like this one working in
Access 97. Have to tell that both, Access 97 and Access
2002 were installed on my computer when I got this
problem. Uninstalling Access 97 din't help.

 

[Van T. Dinh]

1. Is the Table Field actually a DateTime Field?

2. If you ask about Query, please post the SQL String of your Query so that
potential respondent can check.