Some of the most common reporting questions I receive are around formatting dates. All date formats are controlled by formulas entered in the Column Set. You just need to enter them as their own line in the Header Section.
Here are some tips to get you started.
Acumatica Date Formats
This formula gives you the Fiscal Period:
=Report.GetPeriodDescription(@StartPeriod)
Result:
This formula gives you the Fiscal Year:
=Report.FormatYear(@StartPeriod)
Result:
This formula gives you both the Fiscal Period and the Fiscal Year:
=Report.GetPeriodDescription(@StartPeriod)+ ‘ ‘ +Report.FormatYear(@StartPeriod)
Result:
This formula gives you the Long Date:
=’ As of ‘ + Format( ‘{0: MMMM d, yyyy}’,Report.GetPeriodEndDate(@StartPeriod) )
Result:
This formula gives you the Period Covered + Long Date:
=’For the ‘ + CInt(Left(@EndPeriod,2)) + ‘ month(s) ended ‘ + Format( ‘{0: MMMM d, yyyy}’,Report.GetPeriodEndDate(@StartPeriod))
Result:
If you have questions or need some assistance, visit our support page for more help.
