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
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.
Got it. Thanks Paul, your awesome.