Share ways to manipulating on "FinPeriod"

@ray20 It depends on what you’re looking for I think, but there are HistoryByPeriod tables which can store the period data of Last Activity Period.

Additionally, for reports using Report.FormatPeriod(@StartPeriod) + ' to ' + Report.FormatPeriod(@EndPeriod), where @StartPeriod and @EndPeriod are defined as parameters for the report.

Did you end up finding a workaround that you were looking for?

@BenjaminCrisman 
Thank you for your sharing.  Yes, I could get what I want by

The below is supposed to join a period with its pre Period
=IIf( Right( [ItemCustSalesHist.FinPeriodID], 2)='01',CStr( ( Left( [ItemCustSalesHist.FinPeriodID], 4)-1))+'12', [ItemCustSalesHist.FinPeriodID]-1)

I find this works well for my GIs, assuming your financial periods are formatted as MM-YYYY.

=PadLeft( CSTR(Month(@Param_Date)) , 2, '0') + CSTR(Year(@Param_Date))

I’ve been using the following for converting Today() into [ARTran.FinPeriodID] (YYYYMM format). The company I work for has our Financial Calendar start in November and end in October. This is why it starts off by asking if the month is greater than 10. I’ve identified the values that would need to be changed in order for it to work with other months.

Iif(Month(Today())>10,Concat(Year(Today())*100+100,(Month(Today())-10)),Concat((Year(Today()))*100,(Month(Today())+2))

10 represents (Start Month - 1) In my example, it is November (Which is 11, so thus 11 - 1 = 10)
2 is just the remainder of 12 - the above number (12 - 10 = 2)