Hi all

I have seen this before somewhere... what would be the best way to take a shortdate from SQL server database and seperate the DAY, MONTH and YEAR into individual dropdownlist controls?

Kind Regards

Rit

__________________
Rit
www.designandonline.co.uk
INSPIRE | CREATE | DELIVER

Why would you want to do that?

You would have to split the colums as you want in the sql, and then use that as your datasource.

Thanks,

The reason why I want to do this is that I have inherrited a system and the dates are stored with SQL server as a shortdates. I think it would be better for the user of the site to enter dates in this broken down format to keep control of the varying date formats that could be entered.

Unless there is a better solution that I could look at.

Many thanks Rit01

What does the data look like that you are splitting up. Give some examples

In SQL Server they use a datetime field e.g. dd/mm/yyyy - 14/07/1949.

So I would need to find a way of seperating them in SQL so that they can be databound seperately and then also handle the data for when the table is updated.

Rit

I would separate the portions of the date using sql. You can check book on line for string functions such as substring(), mid() .. etc.

Question: Are you populating the drop down lists for data entry? If so, why are you pulling data from the database? Are you giving the users only certain dates they can enter? If there is no restriction, then manually fill the ddl's collection with the values. I guess I am just confused on what exactly you want to do. Also, if you want to let them enter any date, I would use the calendar control. You can restrict the dates they can enter with that control also, so that they can enter a date too far in the past or future.

Hi
The data coming from the databse is if they have provided a date previously i.e. selected values for the dates dropdown lists.

I might just try the calendar control.

Many thanks for your help anyway.

Rit

No problem