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.