VBA not bringing back the correct date

Hi,

So i'm currently using this in VBA:

Please Login or Register  to view this content.

This SHOULD bring back: ("Y:\X\X\X\September\SPR Information (Sep-2013).xls)

But for some reason today it's bringing back: ("Y:\X\X\X\October\SPR Information (Oct-2013).xls)


Any idea why this is doing this.. it was working fine yesterday, but today its thinking that the month is November?

I've also tried changing -1 to -2, and thats bringing back August so thats a bit weird!

Any help - cheers!

hi jonathan.haynes, you could use this:

Please Login or Register  to view this content.

instead of this:

Please Login or Register  to view this content.

Re your issue with the month. When Excel calculates your Format string it gets this:
year - 2013
month - 9
date - 31
It considers this to be 01/10/2013. Yesterday we had 30th of October. As September has 30 days it worked fine. Will work fine again tomorrow less 2

Thanks both!