Showing results for 
Search instead for 
Did you mean: 

Date Convert Routines

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.