Current date in query

STM

Member
Hi Everyone!

I'm creating a query and I have a big trouble...

How can I compare julian dates to current date (for example: IREFFT GE today)?

Thank you all in advice!

Catia
 
Catia,

Just to make sure that no one makes assumptions about what you need
please supply the release level of your software, i.e. A7.3 cum 10, the
model and release level of your i5/iSeries/AS400, i.e. i5 on V5R3, and
what type of query you are talking about, il.e. WW, AS/400 query, or
SQL.

Thanks

Douglas Belcher
KV Pharmaceutical
St Louis, MO
Opinions expressed are not necessarily those of my employer

_____

From: [email protected] [mailto:[email protected]]
On Behalf Of STM
Sent: Monday, March 27, 2006 8:52 AM
To: [email protected]
Subject: Current date in query


Hi Everyone!

I'm creating a query and I have a big trouble...

How can I compare julian dates to current date (for example: IREFFT GE
today)?

Thank you all in advice!

Catia

_____


The entire JDELIST thread
<http://www.jdelist.com/ubb/showflat.php?Cat=3D&Board=3D"WA"&Number=3D"10 4908"

Looking for a job? Check out the Job Opportunites forum
This is the JDELIST World Applications Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing list are
available here <http://www.jdelist.com/unsubscr.shtml> .
JDELIST is not affiliated with JDEdwards(r).
 
Define two date fields as follows, I am using the sales order detail
file F4211 for my example: (TODAY and ORDATE) Then see after on data
selection.

Define Result Fields

Type definitions using field names or constants and operators, press
Enter.
Operators: +, -, *, /, SUBSTR, ||, DATE...

Field Expression Column Heading Len
Dec
TODAY current(date)



ORDATE date(substr(digits(sdtrdj+1900000
),2,7))


Bottom

Field Text
Len Dec
SDKCOO Order Company. . . . . . . . . . . . . .
5
SDDOCO Order Number . . . . . . . . . . . . . .
8 0
SDDCTO Order Type . . . . . . . . . . . . . . .
2
SDLNID Line Number. . . . . . . . . . . . . . .
6 0

More...
F3=Exit F5=Report F9=Insert F11=Display names
only
F12=Cancel F13=Layout F20=Reorganize F24=More keys



Then you do the following for data selection:
Select Records

Type comparisons, press Enter. Specify OR to start each new group.
Tests: EQ, NE, LE, GE, LT, GT, RANGE, LIST, LIKE, IS, ISNOT...

AND/OR Field Test Value (Field, Number, 'Characters', or
...)
TODAY EQ ordate






Bottom

Field Text
Len Dec
TODAY current(date)
8 L
ORDATE date(substr(digits(sdtrdj+1900000),2,7))
8 L
SDKCOO Order Company. . . . . . . . . . . . . .
5
SDDOCO Order Number . . . . . . . . . . . . . .
8 0
SDDCTO Order Type . . . . . . . . . . . . . . .
2

More...
F3=Exit F5=Report F9=Insert F11=Display names
only
F12=Cancel F13=Layout F20=Reorganize F24=More keys



Your report would look like this:
....+....1....+....2....+....3....+....4....+....5....+....6.
Todays Order Order Order Or Line Business
Date Date Co Number Ty Number Unit
 
Re: RE: Current date in query

First of all: I'm talking about AS/400 query, V5R3, JDE World A7.3 cum 4
frown.gif


"TODAY EQ ordate" is always ok, but I need to compare using GE or LE ... and it does not work with formats like MM/DD/YY or DD/MM/YY.

Probably I just need to convert current date in JUL before
smirk.gif


Thank you all!
 
Back
Top