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:#
NumberErrors#
NoneOperation:#
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 |
Examples:#
p2k_spperiod('Q',~)
P2K_PPAMTS.SPELTOT(EEM_ID,P2K_PPAMTS.SPGETPEL('GROSS'),'Q', p2k_spperiod('Q',~))