Sorting Date in Alpha Order By Day (ie. Mon., Tues.) 1

[bethabernathy]

Hi - I am using a query with this syntax:

DayOfWeek: Format([Date],"ddd&quot to return results by the day of the Week ie Monday, Tuesday, etc. I can't seem to get the results to sort in alphanumeric order. I just want the days to report out logically. What I am getting is Friday first, Monday second, etc.

Is there something I can do to get a logical sort.

Thanks, Beth beth@integratedresourcemgmt.com

 

[JohnLowell]

Hi Beth,
Try using the Weekday function to get the number for the day of the week.

=Weekday(#date col#)

Sunday date returns 1
Saturday date returns 7

Hope this helps

 

[bethabernathy]

Hi - I am trying this in my query:

Weekday: Format([Date],"ddd&quot

and I am still not getting the sorting to work. If I use this:

Weekday: ([Date])

This sorts correctly displaying this type of date:

Sunday, November 25, 2001
Monday, November 26, 2001

And what I want to display is just:

Sunday
Monday
Tuesday

etc.

Perhaps if I build another query off of this one parsing out anything after the "," and then use that for my report?

Thanks, Beth beth@integratedresourcemgmt.com

 

[JohnLowell]

Try to format the date column with this:

Weekday: Format([Date],"w&quot

This will give you the day of the week also.

 

[bethabernathy]

Hi John - Thanks that does work, but then how do I get the actual Day ie Monday to appear on the report?

Thanks, Beth beth@integratedresourcemgmt.com

 

[JohnLowell]

Create a different column in the query.

DayofWeek: Format([Date],"dddd&quot {for long names}

Or
DayofWeek: Format([Date],"ddd&quot {for short names}

 

[bethabernathy]

AWESOME!!! Just Perfect. Thank You John! beth@integratedresourcemgmt.com