R
RB Smissaert
Trying to solve the following problem.
I am converting custom Excel dates to the same custom date in Access.
The format is set in a string variable.
The problem is with custom separators.
For example if this custom format is ddd dd/mmm/yyyy
it will give an error in Access as this wants this like this:
ddd" "dd/mmm/yyyy
so the non-standard separators should be enclosed in double quotes.
So, does anybody have a VBA function to convert these custom date formats
from the one
without the quotes to the one with the quotes.
It will have to deal with spaces, comma's, hyphens, underscores, dots and
maybe some more.
I could work it out myself, but I am sure somebody has done this already.
RBS
I am converting custom Excel dates to the same custom date in Access.
The format is set in a string variable.
The problem is with custom separators.
For example if this custom format is ddd dd/mmm/yyyy
it will give an error in Access as this wants this like this:
ddd" "dd/mmm/yyyy
so the non-standard separators should be enclosed in double quotes.
So, does anybody have a VBA function to convert these custom date formats
from the one
without the quotes to the one with the quotes.
It will have to deal with spaces, comma's, hyphens, underscores, dots and
maybe some more.
I could work it out myself, but I am sure somebody has done this already.
RBS