I'm using PFW5.0 and have a date tilde variable in a query statement in
OPAL. Input for this, and other, variables is obtained via a dlg box. The
date is obtained in the format mm/dd/yy. But everywhere else in the
system the user has insisted on date being in the format dd.mm.yy
(Australian date format).
The variable has been set up as:-
In the query statement in the "Date Found" field I have the statement
|Check >~(LostDate - 1)| . An inspection of variables with De*
indicates that the correct information is being transferred to the query.
My problem is that although the results of the query are consistent when
the same dates are entered (as a test) and the results are different for
various entries, the results bear no resemblance to the query input and
are not returning records with a Date Found greater than the date
specified in the variable -1. The results include records with dates
before and after the specified date.
Any help with this would be appreciated. You can either post an answer on