Birthdate Date Format

  • Thread starter Thread starter Dennis Que
  • Start date Start date
D

Dennis Que

How can I show the Month & Day (but not the year) in a report.
Were creating a report of the customers Birthdays.
We keep getting the year included in the report.
We would like to sort by Month & Day.
(Access 2000)
 
In an unbound text field...


=Format([Birthdate],"mm/dd")



To sort, I would make my first sort Month([Birthdate])
and my second sort Day([Birthdate])


This will let you put a group header for month so you could have...



January Birthdates:
John Wilson...............01/08
Sue Jones..................01/25

February Birthdates:
Rick Smith.................02/15


etc.
 
How can I show the Month & Day (but not the year) in a report.
Were creating a report of the customers Birthdays.
We keep getting the year included in the report.
We would like to sort by Month & Day.
(Access 2000)
Click to expand...

To just show the month and day, set the [DateOfBirth] format property
to
mmm dd

will show Jun 21

To sort by month and day, open the reports Sorting and Grouping
dialog.
View + Sorting and Grouping
in the Field/Expression column write:

=Format([DateOfBirth],"mm/dd")
 
I got the date to show month and day, yet I can't get the report to group
the all the Months together.

It sorting on month, but now it is sorting on the year. (1948, 1950, 1961)



fredg said:
How can I show the Month & Day (but not the year) in a report.
Were creating a report of the customers Birthdays.
We keep getting the year included in the report.
We would like to sort by Month & Day.
(Access 2000)
Click to expand...

To just show the month and day, set the [DateOfBirth] format property
to
mmm dd

will show Jun 21

To sort by month and day, open the reports Sorting and Grouping
dialog.
View + Sorting and Grouping
in the Field/Expression column write:

=Format([DateOfBirth],"mm/dd")
Click to expand...
 
Back
Top