Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

Can I do date range in Select Table I/O?

edited Aug 15, 2017 5:00AM in Design Tools & Output Technologies - JDE1 (MOSC) 2 commentsAnswered

Below is my existing table I/O select.  There's a Date field (DWK) also and I want to get records ONLY within a date range, for example in January, from 1/1/2017 to 1/31/2017.  Can I do a Date range in the Table select I/O?  If not, what other solutions can I do please?, right now the only solution I can think of is to loop through the list of returned records and check for the DWK field.  But there could be a lot of records returned.

F06116.Select  [Index 1: Address Num, Date Work, +B]


       |         VA rpt_szDS_BillingDetailJob_MCU [MCU] = TK Business Unit [MCU]

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center