I'm trying to have a SEI view that shows me a week's window of information in a way that the date is variable and not fixed using an specific date in the filter formula. I've tried to use the @@curdate variable is seems is not compatible with mathematical operators.
This formula works to shows everything until current date;
[MFGOPE.OPEEND_0] < '@@CURDATE'
This formula is intended to show me everything until next week (open work orders), but it shows an error.
[MFGOPE.OPEEND_0] < ('@@CURDATE' + 7)
ERROR; A connection with the Sage Enterprise Intelligence server could not be established. Please wait a few minutes and refresh the page.
The idea is to have SEI screen that are open in the shop floor as a visual aid of status of material pending to make.