I'm having a problem with some code in the Select Expert. I have a report that I am running for a Change Management group that requires that they see all changes in a given window that matches either the Scheduled start date or the Requested Start Date. I would think that the following WHERE statement would suffice:
WHERE (("CHG_Infrastructure_Change"."Scheduled Start Date">={ts '2008-06-01 00:00:00'} AND
"CHG_Infrastructure_Change"."Scheduled Start Date"<{ts '2008-06-07 00:00:00'}) OR
("CHG_Infrastructure_Change"."Requested Start Date">={ts '2008-06-01 00:00:00'} AND
"CHG_Infrastructure_Change"."Requested Start Date"<{ts '2008-06-07 00:00:00'}))
Unfortunately it only evaluates whichever is first and ignores the second. Any ideas?
Edited by randcd - 30 May 2008 at 7:32am
IP Logged