I am trying to open a folder that has a fiscal year period.
I have everything that is needed except for the period, for example October month is the 1st fiscal period and September is that last fiscal period (12th).
Here is how my folder path is created:
c:\\financial statement\FY2016\12 Sept 2016\09172016
I can dim the month and the year as as Format(Now, "mmm") and format(Now, "yyyy")
and I can dim the date as Format(Date, "mmddyyyy")
For the fiscal year "FY2016" I have figured out already.
But for the fiscal month period number "12", I cant seem to find in any thread that will convert this month as 12 instead of 9. I did try this:
Format( Now, "mm" + 3) and it gave me a 12 which is good but when October comes, it will change to 13 instead of 01..
Can you someone help with this?
Bookmarks