CASE date variable

[former_member728074]

I am recreating a report from cognos to saps/4 in bobj. I need to create a variable to pull into the report as a column. Here is the cognos expression:

case

when

current_date > [Request Date]
then

current_date - [Request Date]
else null

It does not appear I can use 'case' in a bobj variable? How can I recreate this?

[mhmohammed]

Hi Kate,

Use the below formula

=If(CurrentDate()>[Request Date]) Then DaysBetween([Request Date];CurrentDate())

Thanks,
Mahboob Mohammed

[former_member728074]

Thank you, that worked!!

[mhmohammed]

Hi Kate,

Please make as correct answer, for better visibility.

Thanks,
Mahboob Mohammed

[ayman_salem]

use IF ..THEN ... ELSE ...