By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,049 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

Ordering days in a weekly format

P: 115
i have a tree view that reads in data from a database and allows you to select the year, the programme then populates the weeks you select a week , and then it populates the days within that week from the db. . The issue i am having is ordering these in to monday tuesday wensday etc etc(weekly format). Has anyone got any ideas how i could attempt this

Please note not all weeks have all 7 days and i am using

Cheers in advanced

Jun 25 '08 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 1,295
if you dont mind adding an extra column, write in a new column the day using WEEKDAY function.

then only sort the db with that column.

Jun 25 '08 #2

P: 115
I am looking for a solution that doesn't involve altering the DB in any shape or form. Thanks for the reply
Jun 26 '08 #3

P: 115
I have found a way i have just done several SQL statements specifically picking a distinc single day at a time any questions about this please post
Jun 26 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.