Two digit day only

D

Dan @BCBS

Query 1 has some code that calculates a due date - Date:
IIf([tr.....[ReceivedDate]+30).

Query 2 has only "Date" from query 1.

I create a report with query 1 and the dates are fine.

I use that report as a sub report and it only shows dates that had a two
digit date.
Example: 12/23/07 would carry over fine, but 12/04/07 does not display on
the report when used as a sub report.

I am posting this question to both sobjects Reports and queries because I'm
not sure which are to solve the issue.

Thank you
 
Top