Forum Discussion
Advanced date filter
I give more details,
I have built a report that gives me sales data, which is filtered in such a way (relative date filter), that for example on Friday 17/03 when I open the panel, it shows me the data of the previous day (Thursday 16/03), up to that point I have no problems. The problem is presented to me when I want to review the information on Monday (Only movements are generated from Monday to Friday) and I want to review data from the last day worked
As a consideration, all the dates I bring from my calendar table
- lbendlin3 years agoSuper User
flip your question around. Show transactional data from the maximum date that is not "today". That means if the previous friday was a holiday then on monday you would see thursday data etc.
- Syndicate_Admin3 years agoAdministrator
That's right....... show data of the last working day or worked.