Adding date to file name.

[dajunka]

This has become a major headache for me.

I am simply trying to add the days date to a filename.

FilePathStr = Environment.CurrentDirectory() & "\Data\Data Archive\Padding " & Mydate & ".txt"

'Mydate' is a string made up of datetime.now.day/month/year.
I have also tried inserting , now and today
If I add just one instance of datetime.now.day it works, anymore gives me a DirectoryNotFoundException)

This is really confusing, any help appreciated.

[Alsvha]

Most likely it reads your new file name as directory path if you include characters like / or \ in your date string. Try making your date string with - instead.

[dajunka]

Oh my word, I would not have found that in a million years.

Thanks very much, just changed the little blighter's "/" for "_" and Bobs your uncle. How could something so simple give me more than a days worth of headaches?

[HanneSThEGreaT]

Operating System liek Windows XP etc. do not allow / or \ in file names, I tend to use _ with date values in names

Just remember to mark your thread resolved

http://www.codeguru.com/forum/showthread.php?t=403073