Date Format Formulas ARM

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:

Remember, we are here to help.  If you need additional information or a little help with your reports, send us an email at Support@Crestwood.com.

Leave a Reply