FRFISCAL

Description

The FRFISCAL function provides dates from the fiscal calendar (in Common Services).

Syntax

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

Arguments

option

The period or quarter date you want. Can be Start, End, QStart, or QEnd for the starting or ending dates of the period or the quarter the period is in.

fiscal year

Optional. Assumed to be the current year if not specified. Specify as YYYY (2008), or N1 or L1.

fiscal period

Optional. Assumed to be the current period if not specified. (This field is an integer. It is not enclosed in quotation marks.)

formatted

Optional. Indicates whether the date should be formatted or not. The default if omitted is formatted.

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

Results

FRFISCAL returns the date as a string.

Examples

This statement	Returns this
FRFISCAL("Start")	11/01/2009
FRFISCAL("Start","","O","U")	20081101
FRFISCAL("Start","L1", VALUE(FR("Period")),"F")	11/01/2008

Date formats

The date formats in some versions of Excel are set to jj/mmm/aa instead of dd/mmm/yy if you choose Canada[English] for the country setting in the Windows Control Panel. If you have problems with dates in your statements, choose the International icon from the Control Panel, and select US or Other Country instead of Canada.

See also

 

FR

FRACCT

FRAMT

FRAMTA

FRCREDIT

FRDEBIT

FRPOST

FRRATE

FRSDESC

FRTRN

FRTRNA

FRTRNCR

FRTRNDR