This is version 1 2 3 4 5 6 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

P2K_SPPERIOD#

Functionality#

This database function will convert the date you pass into a period number, for the type of period indicated.

Parameters#

TYPE	The type of period you are working with (see below)
DATE	The date that you want returned in period format

Returns:#

Number

Errors#

None

Operation:#

This function is intended for use with SPELTOT and SPPCTOT type functions. Given the date you have specified, this function will return a properly formatted period number, to use with these functions

The format of Calendar period should match the "to-date" type according to the following table. If, for example, you pass any date in May of 2004, you will get the following results:

Todate_Type	Looking for	Period

|‘Y’ |Year To Date for 2004 |2004 |‘Q’ |Quarter to date for 2nd Quarter|200402 |‘M’ |Month to date for May |200405 Example:

p2k_spperiod('Q',~)

P2K_PPAMTS.SPELTOT(EEM_ID,P2K_PPAMTS.SPGETPEL('GROSS'),'Q', p2k_spperiod('Q',~))