Do not show year of date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field on a table for date of birth. It is formatted as a long date
(displays as May 20, 1963) with the input being dd/mm/yyyy.
How do I show only the month and day on a report?
 
I have a field on a table for date of birth. It is formatted as a long date
(displays as May 20, 1963) with the input being dd/mm/yyyy.
How do I show only the month and day on a report?
Click to expand...

Set the Format property of the control on the report to:
mmm dd

which will display the month as 3 characters, i.e. Sep.

If you wish the full length of the month displayed, i.e. September,
use
mmmm dd
 
Back
Top