Skip to Content
author's profile photo
Former Member

Date Convert Routines

Oct 04, 2005 at 03:46 PM | 16 Views

Where can I find date conversion routine(s) in BW 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

BW (SAP Business Warehouse) | Retail
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Oct 04, 2005 at 05:01 PM

    You have two options for time conversions:

    1. Use the build-in conversion of the update rules if source und target fields are time-char., e.g. move 0calday to 0calyear.

    2. Within the formula builder of the update rules various time conversion functions are offered and can be used ever for non-time-char.

    Add comment
    10|10000 characters needed characters exceeded