Sort days by current day

Y

yann

Hi all,

I have a report where the dates are generated by VBA codes when the reports
are activated based on the current day. I would like to sort the data of the
reports by the day starting from the current day.

For e.g. current day is Tuesday. I would like to have the data on the report
sorted in the following sequence.

Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday and Monday

Sunday and Monday are generated with dates for the following week. I have no
idea if this way of sorting is possible. Please help me if you have any idea.

Thanks in advance! :)
 
Top