Skip to Content
0
Former Member
May 20, 2008 at 08:17 AM

Formula variables

28 Views

I wish to subtract two dates at the query level. I could achieve this by using two formula variables and then creating a formula on these two variables for getting the difference. But in order to get the difference of the two in the query i need to have these two date characterstics in the Rows or need to drill down on these two characterstics at the report level else the formula returns 'X'.

Is there a way i can achieve the difference of the two dates without adding the drill down for these two date characterstics at the report level ? Also without writing any exits. Thx