How to get the financial period name in an ARM Report

  • 10 November 2021
  • 5 replies

Userlevel 5
Badge +3

A client was using the formula MonthName(@MonthStart,-1) in a column heading.  Obviously this use the current date and does not allow the specification of a starting period.  Using Report.FormatPeriod(@StartPeriod,-1) gets the period as 10-2021, 09-2021, etc.  Is there another formula that would return the description of the period as Oct 2021, Sep 2021 etc?


Best answer by dboes14 10 November 2021, 17:30

View original

5 replies

Userlevel 2

=Format( '{0: MMM yyyy}', DateAdd( Report.GetPeriodEndDate(@StartPeriod), 'm', 0))

=Format( '{0: MMM yyyy}', DateAdd( Report.GetPeriodEndDate(@StartPeriod), 'm', -1))

=Format( '{0: MMM yyyy}', DateAdd( Report.GetPeriodEndDate(@StartPeriod), 'm', -2))

Userlevel 3
Badge +1


Userlevel 3

THANK YOU for this example.  Wish the in-app documentation had more examples like this.

Userlevel 5
Badge +3

Thanks, should have more examples like this is help, manuals, and training courses.

Userlevel 5
Badge +3

It does not support the shift option like =Report.FormatPeriod(@StartPeriod,-4)


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2023  Acumatica, Inc. All rights reserved