Search code examples
progress-4glopenedge4gl

Progress 4GL - get today + 1 day

Today keyword gives me today's date, but how can add one (or more) days so I can compare it? I've tried the following code. 

FOR EACH foo
    where date(today) +1 > end_date
NO-LOCK

The error I get is "PREPARE syntax is {FOR|PRESELECT} EACH..."

Solution

  • Just TODAY + 1 - I guess you have a problem in the rest of your dynamic query statement(s):

    hQuery:QUERY-PREPARE (SUBSTITUTE ("FOR EACH foo WHERE end_date < &1", QUOTER (TODAY + 1))) .