| There is no standard mapping from a "fiscal date" to a Gregorian date: Fiscal
year calendars are devised by the accounting departments of various corpora-
tions in whatever way is conveneint for them. (Note that as a start a corpo-
ration - or an individual, if he really wants - can start the fiscal year on
any day of the year.)
A number of years back, I knew some people developing an application within DEC
that needed to work with (DEC) fiscal years. They eventually tracked down the
person in accounting who admitted to being in charge of this - and learned that
she decided how the next fiscal year would be broken down "as soon as neces-
sary", which in practice meant a couple of months before the new FY began.
There was no fixed rule that would let you predict how this would be done.
This was fine for many years, but as increasing numbers of systems needed to
do projections and future planning and such one and two and more FY's out, it
became essential to be able to determine how a FY would be laid out in advance.
So, now there is an algorithm. I'm not sure exactly where to you could find a
copy of the code, but the people who would certainly know are DIS (Digital
Information Systems, our in-house "MIS" people, among other things). You
should be able to find them in the phone book.
Note again that this is a DEC-specific algorithm; there is no "generic" algo-
rithm.
-- Jerry
|
| <<< HUMAN::WRKD$:[NOTES$LIBRARY]DIGITAL.NOTE;1 >>>
-< The DEC way of working >-
================================================================================
Note 397.2* Help with the fiscal calendar. 2 of 2
FROST::W_PIPER "bill piper" 7 lines 2-OCT-1987 04:02
-< FISTIM from the Toolshed >-
--------------------------------------------------------------------------------
It's in the Toolshed already. Look for FISTIM in the VTX Toolshed,
or see topic 676 in METOO::SW_TOOLS_CATALOG (kp7, etc.).
The secret seems to be that a fiscal year ends on the Saturday
closest to June 30.
-piper
|
|
This may help, a set of routines for converting fiscal dates to
roman dates and vice versa.
I suggest you contact RDGE00::DRAPER for further information or
look in this conference.
<<< RDGE28::SYS$COMMON:[NOTES$LIBRARY]BUILDING_BLOCKS.NOTE;1 >>>
-< ADG Building Blocks RTLs >-
================================================================================
Note 2.1 Release Information 1 of 1
RDGE00::DRAPER "Steve Draper" 20 lines 13-NOV-1986 09:57
-< Initial release: V1.0 >-
--------------------------------------------------------------------------------
The current release of the Building Blocks RTLs (V1.0) is installed
on the ADG cluster. The RTLs contain the following routines:
BLK_SHARE
BLK$$FISCAL_ROMAN
BLK$$GET_DISK_QUOTA
BLK$$GET_VERSION_INFO
BLK$$INIT_CTRLY_TRAP
BLK$$REVID
BLK$$ROMAN_FISCAL
BLK$$SETID
BLK_SERVICES
BLK$$RETURN_IDENTIFIERS
BLK$$VALIDATE_IDENTIFIER
Full descriptions of these routines and their usage is given
in the manual BLK010_SYSTEM_MANUAL.DOC, a copy of which is held
in the ISTOOLBOX.
<<< RDGE28::SYS$COMMON:[NOTES$LIBRARY]BUILDING_BLOCKS.NOTE;1 >>>
-< ADG Building Blocks RTLs >-
================================================================================
Note 3.1 Functionality Information 1 of 4
RDGE00::DRAPER "Steve Draper" 22 lines 13-NOV-1986 11:02
-< BLK$$FISCAL_ROMAN >-
--------------------------------------------------------------------------------
Routine Name: BLK$$FISCAL_ROMAN
Language: PASCAL
Mode: USER
Arg #1:-
Name: FISCAL_DATE
Type: STRING (FORMAT = "YYQMWD")
Access: READ
Mechanism: DESCRIPTOR
Usage: FISCAL DATE TO BE CONVERTED
Arg #2:-
Name: ROMAN_DATE
Type: STRING (FORMAT = "DD-MMM-YYYY")
Access: WRITE
Mechanism: DESCRIPTOR
Usage: RESULT OF CONVERSION
Condition values
returned: SS$_NORMAL
SS$_IVTIME
Routine converts fiscal dates to roman dates.
|
| Thanks all, I contacted Steve Draper about the RTL's.. Now if the
network would only cooperate..... I did try FISTIM, but for reasons
I haven't researched, I couldn't get it to run...
Thanks.
Will
|