×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Use the CURDATE current(date), then something like
TODATE curdate - 15 days
Then convert to alpha TOALPHA CHAR(TODATE) then parse from there (it looks like this on our system) 04/15/09. then you can pull the month and year out and compare just the month and year
Hope this helps
John A. Candidi
American European Insurance Group
AS400 & POINT Application Manager
856-779-2274
jacandidi@xxxxxxxxxxxxxxxxx
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Burns, Bryan
Sent: Thursday, April 30, 2009 10:23 AM
To: MIDRANGE-L@xxxxxxxxxxxx
Subject: Month-end queries
At the end of every month, I change the record selection date range in 15 or so queries to reflect the current month in order to get month-end totals. Is there a way to automate this? Of course, the files to be queried may be different so the date fields will not always be the same.
Bryan Burns
iSeries Specialist
ECHO, Incorporated
Lake Zurich, Illinois
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/midrange-l.
midrange.com
