on 08-29-2007 8:34 AM
I am using APO DP v5.
In DP, I am using periods defined as posting periods, for example period number 001 of yeay 2007.
I need to check the posting period in DP macros. Which standard macro function could I use to test the value of the period, specifically the period number within the year and the year?
Thanks,
Bob Austin, Atos Origin
to get the fiscal period in the year use -
"FISCAL_PERIOD(X) returns the number of the posting period specified by column X."
In order to get the Fiscal year in the column
"FISCAL_YEAR (X) returns the fiscal year of the period specified by column X."
if you just want the calendar year -
"YEAR( X ) returns the year of a date that is in whole numbers with reference to the date 0001/01/01. Example: For January 20th 1999 YEAR( DATE( 19990120 ) ) returns 1999"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You want the output as a quarter number?
you can extract weeks into a auxillary row from a macro
WEEK ( DATE ( "choose any cell in the same column "))
This will give the week number as output
Then you write a few more steps around the macro which says if week number = 1 to 13 then Quarter =1, if 14 to 26 quarter = 2 etc
User | Count |
---|---|
8 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.