You have to use the format that you are using for the input options, hence the format the dates actually appear in the report.
for dates in MDY
for dates in DMY
for dates in YMD
When trying to create a filter for a Date field that is General I find that I get an invalid term even though I have enclosed the date in brackets. If I enter the date as a short date the filter seems to work. Since I am double clicking the field name, double clicking the operator and the braces and filling in the date as displayed in the field I don't know if I am just not reading the documentation correctly or there is some other problem. My field properties say Date General. The field displays the date as 20030104. /b[/quote]