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", |
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