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