Sort by date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arlene - 12 Mar 2007 16:54 GMT

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

Reply to this Message

Ofer Cohen - 12 Mar 2007 19:12 GMT

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

Signature

Good Luck
BS"D

> 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

Reply to this Message

Arlene - 12 Mar 2007 23:51 GMT

Thank you never thought to use two sorts

> Are you trying to sort by month and then by day?
>
[quoted text clipped - 7 lines]
> > happen. If I sort =month([date by day]) it does the months descending but
> > not the days. Thanks

Reply to this Message