I am useing the bleow piece of code to define variables for filepaths and filenames.
However one of the files I am looking to define is over a 6month period and as such the file is call 'Sample Report (May 11 - Oct 11)'.
I want to try and avoid having to enter in the variable for 6 months previous (is this example 05 'May').
Is there somthing I could do to have my code define this variable based on counting back 6months from the already defined (10 'Oct')??
Please Login or Register to view this content.