MORE mm/yy problems!!

[Karen]

When I create a report based on a query, all my dates
display properly in mm/yy format. HOWEVER, if I use a
function such as Nz([Clerk.EndDate], "N/A"), clerks with
no end date display the "N/A" as I indicated, but all the
other dates in that column revert to a mm/dd/yy format.
dd defaults to 1 so the dates I actually input as month
and year change to the first of the month and year.. ie
8/02 becomes 8/1/02! HELP!!

 

[Dirk Goldgar]

When I create a report based on a query, all my dates
display properly in mm/yy format. HOWEVER, if I use a
function such as Nz([Clerk.EndDate], "N/A"), clerks with
no end date display the "N/A" as I indicated, but all the
other dates in that column revert to a mm/dd/yy format.
dd defaults to 1 so the dates I actually input as month
and year change to the first of the month and year.. ie
8/02 becomes 8/1/02! HELP!!

One option would be to apply the formatting by replacing the original
date field with a calculated field in the query, like this:

EndDate: IIf([Clerk].[EndDate] Is
Null,"N/A",Format([Clerk].[EndDate],"mm/yy")) AS EndDate

Be sure then to drop any Format property you may have applied to the
text box on the report.