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
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...
ok.. so just saying "DISPLAY DAYS" is not enough?
What would be enough? I thought I did change the data format..lol
nope.... :P
But this was the case (i mean formatting)?
Little reminder: close the topic if it's been solved (see board rules)
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.
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
you can add [Solved] to the subject... You clicked the tick because there's a thumbs up...
Tnx