Aug 3, 2001 #1 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 ..
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 ..
Aug 3, 2001 1 #2 olichap Programmer Joined Mar 20, 2001 Messages 389 Location US Use the CDate function with format like so: format(cdate("12-2-99", "mm/yy" Oliver Upvote 0 Downvote