Group Sort by Min Date

[nmair]

Hello all,

I have 1 group in my report. I sort these gropus in ascending order by min(somedate). However the groups are showing up on my report in descending order, for example, (mar 07 appears before feb 07 and so on)

What am I missing here?

 

[lbass]

Are these actual date fields or have you converted them to text?

-LB

 

[nmair]

These are DateTime fields. No conversions.

 

[lbass]

Just try changing the order to descending.

-LB

 

[nmair]

That works but just wondering if I'm logically correct!

Thanks for the help.