Report Writer - Does

Robert Robinson

Robert Robinson

Reputable Poster
I am creating a report whose primary selection criteria will be "Select all items whose Promised Delivery Date is within (less than) 5 days of Today's Date". My question is: Is there a function similar to the "@Today" function in World Writer that I can use to create a "5 < Today's date" function?
 
Knowledge Garden Document ID ott-00-0060

In RDA:
1. Create a Report Header Section. Make it invisible
2. Insert a Date variable in the section. Change the name to Today’s Date. Make this a Global variable
3. In the DO section, assign SL DateToday to the variable.
4. This variable is now available to be selected in the Data Selection’s right-hand section
 
Then use an arithmetic function in event rules to get the "< 5" function?
 
Yes. My requirement was to allow users to select on a variety of dates ie Today's Date - 1, -2, etc. So just create as many of these variables as needed, give them names like 'Todays Date-1' and users will be able to select them in Data Selection.
 
You can also add the date to Processing Options and then append an =
extra
selection line 'Date=3DProcessing Option Date' to other data selection =
lines.
 
Back
Top