Access 2000 - Extracting DAY filed From Date

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

Guest

Hi,
I am trying to do a report in Access 2000 in which I need to extract the
DAY number out of a date field that is formatted mm/dd/yyyy. I only want the
DAY since I need to sort the records based on the DAY of the month.

Do I need to do this in a Querie or in the REPORT and if so, please
demonstrate HOW to do this.....
My Table name is Membership Table
My Date Field is named Birth Date
 
Hi,
I am trying to do a report in Access 2000 in which I need to extract the
DAY number out of a date field that is formatted mm/dd/yyyy. I only want the
DAY since I need to sort the records based on the DAY of the month.

Do I need to do this in a Querie or in the REPORT and if so, please
demonstrate HOW to do this.....
My Table name is Membership Table
My Date Field is named Birth Date
Click to expand...

Here are several ways.
1) In the report, set the Format property of the [Birth Date] control
to:
dd

2) In the report, use an unbound control. set it's control source to:
=Format([Birth Date],"dd")

3) In the report:
=DatePart("d",[Birth Date])
 
fredg said:
Hi,
I am trying to do a report in Access 2000 in which I need to extract the
DAY number out of a date field that is formatted mm/dd/yyyy. I only want
the
DAY since I need to sort the records based on the DAY of the month.

Do I need to do this in a Querie or in the REPORT and if so, please
demonstrate HOW to do this.....
My Table name is Membership Table
My Date Field is named Birth Date
Click to expand...

Here are several ways.
1) In the report, set the Format property of the [Birth Date] control
to:
dd

2) In the report, use an unbound control. set it's control source to:
=Format([Birth Date],"dd")

3) In the report:
=DatePart("d",[Birth Date])
Click to expand...

4) In the report:

=Day([Birth Date])
 
Back
Top