[Solved] Grouping Dates

[CoginAustin]

I have 1 table. It has a field called DateField. This datefield is a standard datetime(8)
with values ranging from 2005-01-01 to 2005-02-01

So I grag this field in to RS and I see all the dates when I run the report.
I then change the data type to DATE and tell it to "DISPLAY DAYS"=NO
Then I group on DateField in the report. I then get

Jan,2005
Jan,2005
Jan,2005
etc..

Why is it not just giving me Jan, 2005 one time?

If I expand this and include February I get 1 Feb and 1 Jan for each day of each month. I have never seen it do this before so I am not sure this is how it has always been or if something was changed recently that is driving me crazy because I cant group by months

[sir_jeroen]

I think because
Jan,2005 = 1-1-2005
Jan,2005 = 2-1-2005
Jan,2005 = 3-1-2005

And if you group on that...
You must change you dateformatting...

[CoginAustin]

ok.. so just saying "DISPLAY DAYS" is not enough?

What would be enough? I thought I did change the data format..lol

[sir_jeroen]

nope....  :P
But this was the case (i mean formatting)?



Little reminder: close the topic if it's been solved (see board rules)

[CoginAustin]

So turning the display days off doesn't change the data format at all.  Since the groupings are working on the actual data and not the "displayed" version it doesn't work as I need.


Got it.. Thanks.

[CoginAustin]

Another question :)

I clicked the "tick" (check mark) to accept answer. This is not marking it as solved. Can you place more instructions on how to do it in the rules. thanks

[sir_jeroen]

you can add [Solved] to the subject... You clicked the tick because there's a thumbs up...

Tnx