Re: Odd Date selection

On Mar 26, 11:51 am, "dtsig" <d...@xxxxxxxxxxx> wrote:
The Following works ..

SELECT AUDIT_SOURCE WITH chg_date >= "03-20-07" AND WITH chg_date <=
"03-25-07"
[404] 77 items selected out of 2116 items.

This one doesn't

select audit_source with chg_date GE "03-20-07" and with chg_date LE
"03-25-07"
[401] no items present.

the doc says that GE and LE are the same as >= and <= but it appears
that this is not the case.

Any ideas what would be causing this?

In both cases the statement was run from TCL when there select list
was exhausted.

Thanks

DTsig

If this is D3 check the MD entries for each on my system the GE and >=
have "cac" in attr 1 and the le entries have "cbc" in attribute 1.

On thing on you access statement...

It might be better to use: ....with chg_date ge "date" and le
"date"....

Regards,

Dale

.