Day of Week / Date Sort 1

[menuch]

Sunday, June 8, 2003
I need to sort the dates below starting from the current day( Today is June 12) descending. I am showing 2 weeks work of data grouped by dayname so the data can compare 2 like days a week apart. So my question is how can i keep this grouping structure but have it start from the current days name and work backwards?

Sunday, June 1, 2003
Monday, June 9, 2003
Monday, June 2, 2003
Tuesday, June 10, 2003
Tuesday, June 3, 2003
Wednesday, June 11, 2003
Wednesday, June 4, 2003
Thursday, June 12, 2003
Thursday, June 5, 2003
Friday, June 6, 2003
Friday, May 30, 2003
Saturday, June 7, 2003
Saturday, May 31, 2003


Thanks!!

Menuch

 

[synapsevampire]

I don't know what "how can i keep this grouping structure but have it start from the current days name and work backwards" means?

Perhaps you could supply example data and expected output to help clarify?

-k

 

[menuch]

What i mean is I want to keep the Sunday, Sunday, Monday, Monday..... grouping (which is grouped by weekday name)but I want it instead of having Sunday on top to have the currentdays name on top and then go backwards. So today is friday so I would see both fridays data and then thursdays data and so on...

 

[mbarron]

Create the following formula, then group on it, one level above the date group.

remainder(currentdate-({DATE.FIELD}),7)

Suppress the group.

Mike

 

[mbarron]

I forgot to mention that the grouping on the formula should be ascending.

Mike

 

[menuch]

Thanks it worked!!