I have a procedure to export a record to excel. One of the fields is a date field and its set at medium format i.e. dd-mm-yyyy. That is how it appears i the associated tables and form.
I want to include that date in part of the exported filename.
I created a string:
But the procedure is stopping because access is looking at the date as dd/mm/yyy. I think the reason its failing is because you cant name a file with a forward slash.
Is there some way I can format the string at all?
I want to include that date in part of the exported filename.
I created a string:
Code:
strday = Forms![frm_Profile]![frm_Detection]![TrainingDate]But the procedure is stopping because access is looking at the date as dd/mm/yyy. I think the reason its failing is because you cant name a file with a forward slash.
Is there some way I can format the string at all?
