Sort by date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that has information coming in with dates by day. eg February
28, 2007. I am trying to sort in descending order and cannot seem to make it
happen. If I sort =month([date by day]) it does the months descending but
not the days. Thanks
 
Are you trying to sort by month and then by day?

If so, you can use the Month([date by day]) as the first sort, and then add
the second sort

Day([date by day])
 
Thank you never thought to use two sorts

Ofer Cohen said:
Are you trying to sort by month and then by day?

If so, you can use the Month([date by day]) as the first sort, and then add
the second sort

Day([date by day])


--
Good Luck
BS"D


Arlene said:
I have a report that has information coming in with dates by day. eg February
28, 2007. I am trying to sort in descending order and cannot seem to make it
happen. If I sort =month([date by day]) it does the months descending but
not the days. Thanks
Click to expand...
Click to expand...
 
Back
Top