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.