roberthagan
Technical User
I'm in the process of converting some Crystal reports to RS
I need to do things like count for each person how many decisions are due in the current month.
I have in my query (in Oracle 8i) a calculation for DecisionDue_Date, and FirstDayofMonth and LastDayofMonth. I thought I could just find due_dates between the First and Last days:
IIF(DecisionDue_Date >= FirstDayofMonth AND DecisionDue_Date <= LastDayofMonth, 1,0)
But, that always = 0.
To my surprise, even IIF(DecisionDue_Date >= FirstDayofMonth, True, False) is always False.
I found thread1462-1252630 which says "...faff around with VB expressions to convert a date to an integer..." Do I have to do this in my situation? There is no standard function to handle this? (I couldn't find one.)
Thanks
Bob Hagan
I need to do things like count for each person how many decisions are due in the current month.
I have in my query (in Oracle 8i) a calculation for DecisionDue_Date, and FirstDayofMonth and LastDayofMonth. I thought I could just find due_dates between the First and Last days:
IIF(DecisionDue_Date >= FirstDayofMonth AND DecisionDue_Date <= LastDayofMonth, 1,0)
But, that always = 0.
To my surprise, even IIF(DecisionDue_Date >= FirstDayofMonth, True, False) is always False.
I found thread1462-1252630 which says "...faff around with VB expressions to convert a date to an integer..." Do I have to do this in my situation? There is no standard function to handle this? (I couldn't find one.)
Thanks
Bob Hagan