PERTOJ Function
The PERTOJ function returns a Julian value for a specified reporting period in any particular year.
Syntax
PERTOJ("ID",Per#,<Begin or End>, <Year>)
Where
ID is the string representing the reporting period. The available strings are: yearly "Y", semi-annually "S", thirdly "T", quarterly "Q", bimonthly "B", monthly "M", thirteen periods "F", or random "R". Use "" to return the active reporting period.
Per# is an integer representing the particular period. Use zero to return the active period.
Begin or End is an optional parameter. If omitted or entered as zero, the beginning of the period is returned. All other values return the end date for the specified period.
Year is an optional parameter. If omitted or entered as zero, the specified period dates for the current year are returned. Values of 1 through 4 will return dates for the prior 4 years. Negative values can also be used for years.
Example 1
PERTOJ("Q",2,1)
Returns the end date for the second quarter for your client file.
Example 2
PERTOJ("",0)
Returns the beginning date of the current active period for your client file.
Example 3
PERTOJ("M",6,1,2)
Returns the 6th month of prior year 2, set in your client file.
Example 4
PERTOJ("M",6,0,-1)
Returns the 6th month of the first forecast year in relation to the date set in your client file.
