CODEWITHSUNDEEP
progress-4glopenedge4gl
Baked Inhalf
Baked Inhalf

Reputation: 3735

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..."

Upvotes: 1

Views: 1683

Answers (1)

Mike Fechner
Mike Fechner

Reputation: 7192

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))) .

Upvotes: 4

Related Questions