09-15-2003, 08:29 AM
|
|
Freshman
|
|
Join Date: Jul 2003
Posts: 25
|
|
String Help
|
I need some help with something I know is overly simple, but just cant seem to find anywhere. I have a date stored in a field in Access 2k2. In VBA, I pull it into a string variable named DateOut. What I need to do pull the characters to the leftof the first '/', giving me the number of the month, and the two numbers after the last '/', giving me the year.
The point of this, if you were wondering, is that my client wants the date shown in a very specific way, and Access doesnt have a pre-determinded format for it. As such, I need these numbers to format the date correctly by some hand written code. Anyone know how to get these numbers for me, I'd be greatly appreciative.
Braden
|
|
Linear Mode
