Sorting By Date

[slyder04]

Cr 10 Dev
I have a simple report that is grouped by a date and I need to sort those dates starting with August instead of January. I have tried using specified grouping by that did not work. The data is stored as a string (yyyy-mm-dd).

Any Ideas?

Thanks,

Sly

 

[hilfy]

Create a formula that looks something like this:

if mid({table.datefield}, 6, 2) = '08' then '01' + {table.datefield}
else if mid({table.datefield}, 6, 2) = '09' then '02' + {table.datefield}
else if mid({table.datefield}, 6, 2) = '10' then '03' +{table.datefield}
else if mid({table.datefield}, 6, 2) = '11' then '04' +{table.datefield}
else if ...<continue for all months>

Sort by this formula but display your date field.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[slyder04]

Thanks,

That should do the trick.

GJ

 

[SkipVought]

How about

Sort By Month({table.datefield})-7

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

where is my head? That won't work!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[lbass]

if val(mid({table.stringdate},6,2))-7 <= 0 then
val(mid({table.stringdate},6,2))+5 else
val(mid({table.stringdate},6,2))-7

-LB

 

[slyder04]

Thanks for the help, it sorts correctly now.

SL