Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alirockgirl
Starting Member
2 Posts |
 Posted - 2008-07-23 : 13:38:31
|
| I'm trying to order the date of a drop down box in order desc, but I can't I keep seeing it asc. What can I do? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-23 : 13:40:01
|
| is the field storing date values of datetime datatype in your table? |
 |
|
|
alirockgirl
Starting Member
2 Posts |
Posted - 2008-07-23 : 14:01:06
|
| I'm new with this, so please be patient. How do I know that?The problem is that I've been setting the date in Descending order, however it keeps showing me in Ascending order and starts with 1901 (imaging the amount of dates that I have to see to get to 2008!!!)Is there any way I can make it Descending? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-07-24 : 02:55:06
|
| Run thisEXEC sp_help 'table_name'and see what the datatype of the date column isMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Order Date