Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Stored As A String 1

Status
Not open for further replies.

saw15

Technical User
Joined
Jan 24, 2001
Messages
468
Location
US
Good day ..

Working with a DB that stores the date as a string, is there any way to convert this back to a date?

Or is there any way to pull just the month or year out?

Thanks ..
 
Use the CDate function with format like so:

format(cdate("12-2-99"), "mm/yy")

Oliver
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top