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',~))