wrong month displays in access report

[Nutmeg]

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.

 

[Van T. Dinh]

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.

 

[Nutmeg]

So simple....thanks for your help!!

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)

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.