Where can I find date conversion routine(s) that will take a DATS formatted field, YYYYMMDD, and return:
1) Calendar Day
2) Quarter
3) Calendar year/quarter
4) Calendar year/Month
5) Calendar month
6) Calendar Year/Week
7) Calendar Year
8) Weekday
9) Fiscal Year/period
10) Posting period
11) Fiscal Year
1 Answer
-
Oct 04, 2005 at 04:29 PM
> Where can I find date conversion routine(s) that will
> take a DATS formatted field, YYYYMMDD, and return:
> 1) Calendar Day
<i>Use offset date+6(2)</i>
> 2) Quarter
> 3) Calendar year/quarter
> 4) Calendar year/Month
Use offset date0(4) for year and date4(2) for month
> 5) Calendar month
Use offset date+4(2) for month
> 6) Calendar Year/Week
Use offset date+0(4) for year
> 7) Calendar Year
Use offset date+0(4).
> 8) Weekday
DATE_TO_DAY or DAY_IN_WEEK or DAY_ATTRIBUTES_GET
> 9) Fiscal Year/period
RKE_CONVERT_DATE_TO_PERIOD
> 10) Posting period
RKE_CONVERT_DATE_TO_PERIOD take offset PERIO+4(3)
> 11) Fiscal Year
RKE_CONVERT_DATE_TO_PERIOD take offset PERIO+0(4)
Add comment
Add comment