Diiference between two date & time prompts

[laks]

Hi Folks,

I am trying to find difference between two date & time prompts.

Here is my scenario..

I have From and To date & time prompts. I want to find the difference (either in days or months) and use that in conditional block. I want to create a variable on that. I achieved this in SQL but I am having hard time in using that data item in creating a variable.

Can someone suggest, how to do this.

Thanks,
Pavan

[CognosPaul]

In order to use a data item inside a variable, the variable needs to be triggered from within an object set to the query. In 8.4 you could use a singleton with the difference field in the properties.

[laks]

Got it. Thanks Paul, your awesome.