MORE mm/yy problems!!

  • Thread starter Thread starter Karen
  • Start date Start date
K

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!!
 
Karen said:
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!!
Click to expand...

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.
 
Back
Top