Skip to Content
author's profile photo
Former Member

Date Convert Routines

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

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
    10|10000 characters needed characters exceeded