Need to remove "/" from a date programatically.

  • Thread starter Thread starter Weeble
  • Start date Start date
W

Weeble

I am trying to automate exporting a couple of reports to Excell. The output
file name will be the recipients initials, i.e. DZ with the date of the
export appended to it. DZ122909 I can get the date from a date control on the
form initiating the Sub, but I can find nothing on how to find and remove
characters from a string. Is this possible with Access and can you point me
in the right direction?

Thanks,
 
Thanks to both of you for your help.

Clifford,

I haven't had that issue yet, but I can resolve that by including a company
identifier or even a department identifier if it comes to that. But thanks
for thinking of that, I would rather address it now than wait for it to bite
me in the Format(A_ _, "_ SS").
 
Back
Top