Re: Month-end queries

Assuming you can't switch to a more modern solution...

You could either create a date file like some others have mentioned, or....

In 'Define Result Fields' you can use the CURRENT(DATE) function to get the current date in MM/DD/YY format. You could then use a mixture of CHAR(), SUBSTR() and DATE() functions to set up a date literal in the proper format. Note that these functions may cause an appreciable performance hit.

Glenn

Burns, Bryan wrote:

We use Query for iSeries also known as Query/400, et al.
Bryan Burns
iSeries Specialist
ECHO, Incorporated
Lake Zurich, Illinois

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Glenn Hopwood
Sent: Thursday, April 30, 2009 9:30 AM
To: Midrange Systems Technical Discussion
Subject: Re: Month-end queries

Most of the query tools allow you to pull in the current month. Each of
them have different ways of doing it. Which tool are you using?

Glenn

Burns, Bryan wrote:

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.