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.