Date filter on reports

[Guest_imported]

I use Paradox 9 interactively. I tried last week to filter a report to give me information based upon dates in a date field. Example:

> 04/04/2002 < 04/16/2002

Got an error message. What's the syntax?

 

[footpad]

Daniel,

Try: > 04/04/2002, < 04/16/2002

Hope this helps...

-- Lance

 

[Guest_imported]

Hmm..I did try that...but w/o the comma.

 

[JoeRestle]

There has to be a better way to deal with this problem than my current solution.

Given:
1. A normal query creates an answer table. The format of that table is either Paradox's default or a custom format that can be created using the Query Properties dialog box.

2. I want the answer table in the format of a results file. (Which contains the found data formated for my comfort)

The technique for accomplishing this has been to copy the result table to the private answer table. Since this invalidates the *.val files, I have to delete the answer.val files before the query will run. My current technique is to go to DOS, delete the *.val files, go back to Paradox and run the query.

This seems to be way too convoluted. What am I missing?