Skip to Content
0
Former Member
Mar 24, 2006 at 04:30 PM

Bex report - dates subtraction

51 Views

Hi,

I need to do a subtraction between 2 dates (posting date - document date) but posting date can be blank. I have created a calculated KF and a restricted KF(using the calc KF and posting <> #). My issue has to do with the result. I am getting -2.345678901E+298 value for all lines. Also I have changed to display 0 as number of decimals. Please can someone tell me how I could fix it or give to me another way to do it?

See below the calc KF:

NODIM ( DATE ( 'Posting date' ) - DATE ( 'document date' ) )

Thanks a lot.

Cesar