So if you want to create a flag for those months, then yes its absolutely possible, but just make sure you define it as per requirements like for 2001 its Aug, 2002 Sep, etc.
There should be some logic as to how this base month for each year is defined. Without this logic say for next year to assign a month you would have to go and manually code it.
Hope it helps.
Questions on the end goal:
What will you compare the First Month Index to?
Is it to see how long a product has been in use? (basically the same as above)
Can there be more than one entry per customer?
To me there's not enough info to model your data, but yes, you can do what you describe.
There cant be more than one Fiscal Year Begin Date per client. The reason I need this is to Fiscal Year Comparisons. I need to normalize all the months so I have a Fiscal Month 1,2,3,4,etc... and the month is relative to the Fiscal Year Start Date...so for client a, b, c can have different start dates (july, sept, jan)...Fiscal Month 1 should refer to july, sept, or Jan. depending on their FY setup. Does this help and if so can you show me how to accomplish this.
I am not sure what you are asking but here is what I have:
From there I want to show:
AccountName - XYZ
BillStartDate - 1/1/2013
FiscalYearStartDate - 7/1/2012
Month(FiscalYearStartDate) as Month - 7
Month Index 1 since 7/1/2012 is the FiscalYearStartDate
AccountName - ABC
BillStartDate - 2/1/2013
FiscalYearStartDate - 8/1/2012
Month(FiscalYearStartDate) as Month - 8
Month Index 1 since 8/1/2012 is the FiscalYearStartDate
Does this make since?