Sort by 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
 
G

Guest

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])
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top