Monkeyboy126
IS-IT--Management
Hi
Can anyone tell me why the Select formula below isn't working? The database (SQL) is for a helpdesk logging problem and changes and the formula will only display closed calls (so ignores the second part of the formula)
({int_org.iorg_name} = "Company x" and {@Close Date} in MonthToDate)
or
{int_org.iorg_name} = "Company x" and {chg.active_flag}=1.00
Any ideas would be greatly appreciated
Paul
Can anyone tell me why the Select formula below isn't working? The database (SQL) is for a helpdesk logging problem and changes and the formula will only display closed calls (so ignores the second part of the formula)
({int_org.iorg_name} = "Company x" and {@Close Date} in MonthToDate)
or
{int_org.iorg_name} = "Company x" and {chg.active_flag}=1.00
Any ideas would be greatly appreciated
Paul