Calculate number of days between two dates

[former_member463021]

Hello,

I'd like to get a report that it calculates number of days between two dates.

One of them (date1) it hasn't values in a infoprovider, it is a user variable.

When a user executes the query, it shows a variable, user introduces a date (date1), and report shows a calculated ratio = date1 - date2 (date2 values are saved in a infoprovider).

The report hasn't filters.

Thanks.

[Loed]

Hi,

First, convert your DATE2 to KF..Follow the document below..

Then create another formula variable but instead of choosing INFOOBJECT in the replacement path tab, choose VARIABLE, enter the variable of your DATE1.

Then you may now create a formula to subtract the two (2) formula variables (FV)..

FORMULA = DATE1_FV - DATE2_FV

Regards,

Loed