K
KidSensation
I have a date field in my table that comes in as text in the format
'4282007' and I need to be able to convert this string to an actual
date. Since it's not a valid date expression CDate() will not work on
it. So my thought was to insert '\'s into the strings and they will
then be valid. However, I'm finding it quite impossible to either use
string indexes to access individual chars or split the string into an
array. Is there anyway to do this in Access 2003? or should I just
look for a new way to do this? Thanks.
'4282007' and I need to be able to convert this string to an actual
date. Since it's not a valid date expression CDate() will not work on
it. So my thought was to insert '\'s into the strings and they will
then be valid. However, I'm finding it quite impossible to either use
string indexes to access individual chars or split the string into an
array. Is there anyway to do this in Access 2003? or should I just
look for a new way to do this? Thanks.