Short Date Question

  • Thread starter Thread starter BobV
  • Start date Start date
B

BobV

Group:

I have a field in a table that is formatted as a Short Date (mm/dd/yyyy). Is
there a way to shorten the year to two digits when printing the date on a
report? I have chosen Short Date for the field on the report, and I don't
see anyway to change the year to two digits.

I want to keep the complete date in the actual table field, and to save a
little bit of space on the report when it is printed - there is a lot of
data for each line of the report.

Thanks,
BobV
 
Use mm/dd/yy as your format, not "Short Date".

You can either do this in the query on which your report is based by adding
a computed field ShortDate: Format([MyDate], "mm/dd/yy"), or you can set the
Format property of the text box on the report.

But are you sure you want to suggest to your users that a 2 digit date is
acceptable?
 
Doug:

Thank you for your help. I used your suggestion regarding formatting the
text box as mm/dd/yy.

I understand your concern about giving the user the impression that a 2
digit year is acceptable, but I have the date field on my form formatted so
that a 4 digit year must be entered. I just need the extra space (albeit
only 2 spaces) for an additional field that I squeezed into the form.

Thanks again,
BobV

Douglas J. Steele said:
Use mm/dd/yy as your format, not "Short Date".

You can either do this in the query on which your report is based by adding
a computed field ShortDate: Format([MyDate], "mm/dd/yy"), or you can set the
Format property of the text box on the report.

But are you sure you want to suggest to your users that a 2 digit date is
acceptable?

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



BobV said:
Group:

I have a field in a table that is formatted as a Short Date
Click to expand...
(mm/dd/yyyy).
Is
there a way to shorten the year to two digits when printing the date on a
report? I have chosen Short Date for the field on the report, and I don't
see anyway to change the year to two digits.

I want to keep the complete date in the actual table field, and to save a
little bit of space on the report when it is printed - there is a lot of
data for each line of the report.

Thanks,
BobV
Click to expand...
Click to expand...
 
Back
Top