FRFISCAL Function

Sage 300 ERP

FRFISCAL Function

This function returns a date (as a string) from the fiscal calendar in Common Services.

Syntax

FRFISCAL(option, fiscal year, fiscal period, formatted)

Arguments

Argument Description
option

The period or quarter date.

Valid parameters are:

  • Start: Start date of the period
  • End: End date of the period
  • QStart: Start date of the quarter
  • QEnd: End data of the quarter
fiscal year (Optional)

Valid parameters are:

  • YYYY: A specific 4-digit fiscal year, such as 2010
  • Ln:nyears ago, relative to the current fiscal year; for example, L1 is last year, and L2 is 2 years ago
  • Nn:nyears in the future, relative to the current fiscal year; for example, N1 is next year, and N2 is the year after next

If not specified, assumed to be the current year.

fiscal period (Optional)

Fiscal period number from 1 to 12. If not specified, the current period is used.

Note: This field is an integer so is not enclosed in quotation marks.

formatted (Optional)

Indicates whether the return value should be formatted according to the presentation defined in the view. If omitted, the default is "Formatted." Use one of the following constructs:

  • "FORMATTED", "F", or "FMT"
  • "UNFORMATTED", "U", or "UNFMT"

Examples

Statement Return Value
=FRFISCAL("Start") 11/01/2009
=FRFISCAL("Start","","O","U") 20081101
=FRFISCAL("Start","L1", VALUE(FR("Period")),"F") 11/01/2008

Related Topics