Skip to Content
0
Former Member
Sep 07, 2006 at 04:55 AM

Addning dates in BW 3.1

15 Views

Hi Guys,

I have two fields, One is a date field in the normal date format of XX/XX/2006 (z_podate) and another field which is a number. This number field stores a 'number of days' value (z_deldays). How can I add z_podate and z_deldays as I want to get a result and compare to another date field in a start routine of an update rule? Can I do this in the Update rules as follows:

IF COMM_STRUCTURE-/bic/z_podate+COMM_STRUCTURE-/bic/z_deldays <

COMM_STRUCTURE-/bic/z_deldate.

RESULT = 1.

ELSE.

RESULT = 0.

ENDIF.

Will This work? Or shall I add them in BEx. I think adding the number of days to the date field may not work?! Does anyone have any ideas?

Thanks

Depesh