• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Select 'current date' in Data Selection

ymchou

Member
Select \'current date\' in Data Selection

Hello there,

I have a requirement whereby I need to select the GL date as a date which is
less than the current day in the data selection of the Dream Writer reports
eg. Sales Update.

Instead of going into the data selection values to key in eg.
GL date LT 11/28/00
at the GL Date field, is there a way to set it so that the system will
know that we want to default in the current date at the Selection Value
column.

This is important as we set up a number of versions of the sales update pgm
to be run as a sleeper jobs. It would be cumbersome to have to remember to
go into the version to change the GL date everyday.

Anyone has any idea how I can improve on this set up?

Many many thanks in advance!

Regards,
May

_____________________________________________________________________________________
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
 
G

Guest

Guest
RE: Select \'current date\' in Data Selection

Sure, just use EQ *Today in the selection criteria. This has worked in
World for several years. I hear that it now works in OneWorld in Xe, but I
haven't tested it myself.

Andy Klee
970 856 4811
www.JDETips.com
 

ymchou

Member
RE: Select \'current date\' in Data Selection

Thanks! I've tested & it works.

>From: andyklee9 <andyklee@myexcel.com>
>Reply-To: jdeworld@jdelist.com
>To: jdeworldml@jdelist.com
>Subject: RE: Select 'current date' in Data Selection ~~1856:1864
>Date: Wed, 29 Nov 2000 01:56:08 -0800 (PST)
>
>Sure, just use EQ *Today in the selection criteria. This has worked in
>World for several years. I hear that it now works in OneWorld in Xe, but I
>haven't tested it myself.
>
>Andy Klee
>970 856 4811
>www.JDETips.com
>
>
>
>
>
>
>
>--------------------------
>To view this thread, visit the JDEList forum at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=1864
>*************************************************************
>This is the JDEList World Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>

_____________________________________________________________________________________
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
 

tpayne

Reputable Poster
RE: Select \'current date\' in Data Selection

You can also use a formula (eg: *today - 30) in Dreamwriter to select
anything greater or less than 30 days ago.
One good use is in archiving data where you want to retain data for 2 years
(approximately!) - set up a P00PURGE version for the file selecting data
with a date less than *today - 730.
You can always test the results of your date formula in the OPNQRYFL
statement generated by DW by using option 7 on the version.
As Michael Caine would say "and not many people know this......"
Hope this helps.

----------------------------------------------------------
Tony Payne - Senior Systems Analyst
United Musical Instruments USA Inc.
1000 Industrial Parkway
Elkhart, Indiana 46516
Tel: (219) 295 0079 ext. 2337
Fax: (219) 295 8613
Email: tpayne@umi-usa.com
(Running JDE A73 cum 10 on V4R3M0)
 

scott_parker

Reputable Poster
Re: Select \'current date\' in Data Selection

Also keep in mind that you can do *today -1 for yesterday or -2 for the day before etc etc.

Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R4 (soon to be V4R5)
 

CBallou

Member
RE: Select \'current date\' in Data Selection

You can write a CL and RPG to update the F98301 for that Dream Writer using
the system date and place it in your sleeper job.
 

rlevesque

Member
RE: Select \'current date\' in Data Selection

HI, Will selecting the current date in World Writer work the same way? I
tried using EQ *TODAY and I get a syntax error. Please advise.

Thanks, Ron.
 

tpayne

Reputable Poster
RE: Select \'current date\' in Data Selection

Sorry - NO.

I'm not sure what Query functions are available in Worldwriter, but all
Dreamwriter does is generate an OPNQRYF (Open Query File) statement, which
is a CL command. If you look at this command in the CL manuals, any of
the data selection formulae given there should be allowable in a
Dreamwriter data selection.
Worldwriter is another animal though.........................
 

scott_parker

Reputable Poster
Re: Select \'current date\' in Data Selection

the *today function does not work with WW.
(and that sucks)

Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R4 (soon to be V4R5)
 
Re: Select \'current date\' in WW Data Selection

There is a way around this but it can be cumbersome for ad-hoc
requirements. You simply run a version of P00365 nightly in
sleeper (into a seperate environment if you already use F00365)
with start & end dates specified in the processing options.

As P00365 is a DW based program you can use the *today function
to populate the F00365. This will give you a F00365 which
contains all the dates in the range you are after. Join this to
the field that you want to apply date selection on and you
should be right.

If you have a number of date requirements eg today, yesterday,
last 30 days, last 60 days then you would need to run one
P00365, a CL to copy file (F55TODAY, F55YESTDAY, etc), next
P00365 and so on.

Keith Sherman


--- scott parker <scott.parker@grote.com> wrote:
> the *today function does not work with WW.
> (and that sucks)
>
> Scott Parker
> Grote Industries, LLC.
> WorldSoftware Version 8.1.2 AS/400 V4R4 (soon to be V4R5)
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=1982
>
> *************************************************************
> This is the JDEList World Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>


__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/
 

JBurd

Member
RE: Select \'current date\' in Data Selection

At one time, JDE recommended using a join to the F00365 (if you're not
already using it for other purposes), which would somehow contain only the
system date. I don't know the details, but they had a white paper
detailing how this should be done.

Also, you could look at the technique developed by one of this list's
subscribers (available on the JDELIST website). It's a little cumbersome
in that each version needs it's own CL program, but otherwise it works OK.




rlevesque
<rlevesque@hsi-inc To: jdeworldml@jdelist.com
.com> cc:
Sent by: Subject: RE: Select 'current date' in
owner-jdeworldml@j Data Selection ~~1856:1944
delist.com


11/29/2000 02:55
PM
Please respond to
jdeworld





HI, Will selecting the current date in World Writer work the same way? I
tried using EQ *TODAY and I get a syntax error. Please advise.

Thanks, Ron.




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=1944

*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 

tpayne

Reputable Poster
RE: Select \'current date\' in Data Selection

We have a copy of the white paper fix somewhere - just need to dig it out
for you to get the reference.
It's a bit of a clunky solution, and having to join the files is a real
PAIN - I think that writing an RPG program to put todays date into the JDE
files for a given WW version before executing it is maybe a better
solution. You don't need a separate program for each version - just pass
in the Group/Version to a standard RPG program.
I used to do the same for DFU's on S/36 - have a standard program to modify
the DFU source before running it - it's a relatively simple solution.
 
Select \'current date\' in Data Selection

Ron,

You can (re-)generate a version of the F00365 containing just a single
record equivalent to today's date by running the DREAM Writer (P00365, I
think) with a blank processing option for the date range.

You could also use Job Stream, a simple CLP or the like to submit this
DW prior to a WW using a join to this file to give records that satisfy
the appropriate dates criterion, such as "=today".

In my experience, such a straightforward WW join is not such a big deal
since the second file is, by definition, extremely small.

HTH.


In message <200011301646.IAA11097@shell.tsoft.com>, JBurdman
<JBurdman@dataprofit.com> writes
>
>At one time, JDE recommended using a join to the F00365 (if you're not
>already using it for other purposes), which would somehow contain only the
>system date. I don't know the details, but they had a white paper
>detailing how this should be done.
>
>Also, you could look at the technique developed by one of this list's
>subscribers (available on the JDELIST website). It's a little cumbersome
>in that each version needs it's own CL program, but otherwise it works OK.
>
>
>
>
> rlevesque
> <rlevesque@hsi-inc To: jdeworldml@jdelist.com
> .com> cc:
> Sent by: Subject: RE: Select 'current
>date' in
> owner-jdeworldml@j Data Selection ~~1856:1944
> delist.com
>
>
> 11/29/2000 02:55
> PM
> Please respond to
> jdeworld
>
>
>
>
>
>HI, Will selecting the current date in World Writer work the same way? I
>tried using EQ *TODAY and I get a syntax error. Please advise.
>
>Thanks, Ron.
>
>
>
>
>--------------------------
>To view this thread, visit the JDEList forum at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=1944
>
>*************************************************************
>This is the JDEList World Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>
>
>
>
>
>
>
>
>--------------------------
>To view this thread, visit the JDEList forum at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=2011
>*************************************************************
>This is the JDEList World Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>

numberseven
 
Top