DE48687, NAB
query should be updated as below:
SELECT @SELECT:p.prid:
[email protected],
@SELECT:to_char(p.prstart, 'mm/dd/yyyy')||' - '||to_char(p.prfinish-1, 'mm/dd/yyyy'):
[email protected]FROM prtimeperiod p, prtimeperiod c
WHERE SYSDATE BETWEEN c.prstart AND c.prfinish-1
AND (p.prstart BETWEEN c.prstart-28 AND c.prstart-14
OR (to_char(SYSDATE,'D') > 3 AND SYSDATE-7 BETWEEN p.prstart AND p.prfinish-1))
AND @
[email protected] ORDER BY p.prstart