Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
AS400 Query, Define Result Fields, Date/Time
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... -
AS400 Define Results-Query...need Date help
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... -
AS400 Query, Define Result Fields, Subtracting 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...
