low_date not working with field value ?

[subhendra]

Hi everyone,

I had written a query which accepts paid date as selection criteria. If paid date range is blanked then i assign to low_date and hi_date as per QAD standard. But this doesn't return record where AR paid date field having ? value. How can the query be written for such cases. below is the query example ...

*************
{mfdeclre.i}

define variable ardt like ar_date.
define variable ardt1 like ar_date1.
define variable dt like ar_paid_date.
define variable dt1 like ar_paid_date.


update ardt
ardt1
dt
dt1
with frame a.

if ardt = ? then ardt = low_date.
if ardt1 = ? then ardt1 = hi_date.
if dt = ? then dt = low_date.
if dt1 = ? then dt1 = hi_date.
for each ar_mstr where ar_date >= ardt and ar_date <= ardt1
and ar_paid_date >= dt and ar_paid_date <= dt1
no-lock:
disp ar_mstr with 2 col.
end.
***************

Thanks for reply.
Subhendra.

 

[kishorchari]

Put message for ardt after assigning low_date to verify the value.

What is the O/S version?

 

[zee]

Add condition where ar_paid_date = ?

and (ar_paid_date = ? or (ar_paid_date >= dt and ar_paid_date <= dt1))

 

[Kishor Chari]

How can one get ? in date field? Is ? less than low_date.

 

[shivakumarpatil]

hi,

This query is working perfectly in my system without errors.

eB2.1 SP4
9.1E
UNIX

Shiva

 

[zee]

How can one get ? in date field? Is ? less than low_date.

? is the unknown value for the date field. It does not evaluate to true for either less than or greater than... you must check for it explicitly.

 

[subhendra]

Thanks buddies.

I have changed my query with the following condition and it's working.

-------
and ((ar_paid_date >= pdate)
and (ar_paid_date <= pdate1)
or (pdate = low_date and ar_paid_date = ?))
--------

Thanks all the reply and help.

 

[subhendra]

How can one get ? in date field? Is ? less than low_date.

? is the unknown value which is by default added to the ar_paid_date field when record is created.

Regards,
Subhendra.

 

[subhendra]

Put message for ardt after assigning low_date to verify the value.

What is the O/S version?

QAD 9.0 SP2 with Progress 8.3B. This problem also happens with OpenEdge 10.1C SP2 with QAD 2009 SE.