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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.