Date Convert Routines

[Former Member]

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

😎 Weekday

9) Fiscal Year/period

10) Posting period

11) Fiscal Year

[Former Member]

> 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).

> 😎 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)