Pulling parts of a date from a SQL table using VB

[JoeCool32]

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? JJ

"Ignorance and prejudice and fear walk hand in hand" - Witch Hunt, by Rush

 

[Zarcom]

Get the data into a date type variable then simply use the
.day
.month
.year
to pull out the part of the date that you want. That'l do donkey, that'l do
Mark
If you are unsure of forum etiquette check here faq796-2540

 

[JoeCool32]

I'll see how to work that in. Thanks. JJ

"Ignorance and prejudice and fear walk hand in hand" - Witch Hunt, by Rush