Search results for query: *

I'm actually not certain what kind of field it is, it says ZONED in the file definition. I can do select records by typing in ISADATE RANGE '2008-05-27' '2008-05-30' and it comes out with the correct records.

Shoot, and I was thinking that would work. :( I'm still getting no records TODAY CHAR(CURRENT(DATE),ISO) HRS72 CHAR(CURRENT(DATE) - 3 DAYS,ISO) ADMDT CHAR(ISADATE,ISO) select records ADMDT GE HRS72

yes, I got that far for both TODAY and HRS72. My problem is that when I go into select records, no records come up. ISADATE GE HRS72 ISADATE shows on record as 2008-05-01 HRS72 shows on record as 05/01/08 I even tried doing ADMDT DATE(ISADATE) to have it show up the same, then tried...

I am using the AS400 Query, we are in version V05R03M00 IBM iseries. I am building a query that I need to get all record 72 hrs prior. I have been trying to set up define results fields for this with no luck. I set up so that HRS72 TODAY - 3 days, but then couldn't select records so that...

We are in version V05R03M00 IBM AS400. I am trying to build a query, and need to select records using Transaction Date (ISOTRDATE) of the first day of the current month to yesterday. (will run daily). I need to set this in Select Records so that the query can be run with no prompting for date...

I am mostly self taught using the AS400 Query, we are in version V05R03M00 IBM AS400. I am trying to build a query, and need to select records using Service Date(SRVDT) of eight days ago from today to yesterday. (will run on Thursday morning for last Thursday 12:00am to yesterday, Wednesday...