• 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!

E9.1 Data Selection - Today's Date plus X days

richchipper

Active Member
Is it possible to create a data selection on a standard JDE report with today plus X days? So, I want to run a report for everything expiring the next seven days. We are trying to put a report on the scheduler to process MRP messages (R3411) for the next five days, but I can't find a way to make that happen.
 

Randy_E

Member
Create a variable using the DD Item for the date you are looking to set data selection on. In the "Initalize Section" of the report, use the "X=" to set the date ahead. You will select the variable = "Advance Function" (Date Functions). The first option is Add_Days (,). Your code will look similar to this: Date_Var =Add_Days (SL DateToday,7). You will find the SL value in the box, left of the Advanced Functions.
 

jdedwardsuser

Active Member
I think you are asking whether you can do that in data selection external only and not change code on a vanilla in this case, add processing option for how many days etc . Out of the box jde does not allow you to do it . It will be wonderful to have that , but we dont have it ... I know Patwel group is great in creating some handy tools like this to address such needs but I dont think they have this yet . I know they have something for adding a list like IN clause in data selection which out of box jde even does not have and we have to press that + button to add values
 

eydeak

Reputable Poster
There is an enhancement request to be able to do this kind of thing in version data selection. I encourage anyone who is a Quest member to login and vote for it.
 
Top