wrong month displays in access report

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

Guest

I have a group heading on a report on a date field and have it set to group
by Month. I am using this expression in the control for the heading:
=DatePart("m",[dteExpediteRequestDate]) The format is set to "mmmm"

The report is based on a parameter query where the user enters a date range.
I currently only have 4 test records in the database, all dated in December.
(The date is auto-populated).

When I run the report and enter 12/1/05 start and 12/31/05 end, the month
displayed in my heading is January. Does anyone know how I can make it say
December?

Thanks.
 
Just use:

[dteExpediteRequestDate]

and leave the Format Proerty at "mmm" or use:

Format([dteExpediteRequestDate], "mmm")

and don't worry about the Format Property.

See Microsoft Office article:

<http:/office.microsoft.com/en-us/HA011102181033.aspx>

for explanation on JET Date/Time.
 
So simple....thanks for your help!!

Van T. Dinh said:
Just use:

[dteExpediteRequestDate]

and leave the Format Proerty at "mmm" or use:

Format([dteExpediteRequestDate], "mmm")

and don't worry about the Format Property.

See Microsoft Office article:

<http:/office.microsoft.com/en-us/HA011102181033.aspx>

for explanation on JET Date/Time.

--
HTH
Van T. Dinh
MVP (Access)



Nutmeg said:
I have a group heading on a report on a date field and have it set to group
by Month. I am using this expression in the control for the heading:
=DatePart("m",[dteExpediteRequestDate]) The format is set to "mmmm"

The report is based on a parameter query where the user enters a date
range.
I currently only have 4 test records in the database, all dated in
December.
(The date is auto-populated).

When I run the report and enter 12/1/05 start and 12/31/05 end, the month
displayed in my heading is January. Does anyone know how I can make it
say
December?

Thanks.
Click to expand...
Click to expand...
 
Back
Top