Pulling parts of a date from a SQL table using VB

[joethecool1]

I've got two date fields in a SQL table, dateStarted and dateEnded. I'm trying to pull the day, month and year info from them into separate ASP textboxes (i.e. txtMth, txtDay, txtYear, txtMth2, txtDay2, txtYear2) using VB. Assuming I've already opened the SQL connection how would I proceed to populate the textboxes w/ the days, months, and years separately?

[Eras3r]

Retreive the data into a Date variable type, and there should be some methods you can use to extract day,month,year, etc...

Or retrieve date into a String, and use the Split() method to seperate the parts.