Date Convert Routines

[Former Member]

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

😎 Weekday

9) Fiscal Year/period

10) Posting period

11) Fiscal Year

[Former Member]

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.