I have a sales data model which joins to a date calendar table. I have a list box for the fields from the calendar Day, Month, Year so the users can select the dates they wish to see. I also have a calendar object that looks at two variables vStartDate and vEndDate, when the user clicks on the macro button next to these objects it will execute the following Actions
='=Date >= vStartDate and Date <= vEndDate'
The problem I am facing is that there are some invoice dates where there hasn't been any invoices done on that day i.e. a weekend but if the users entered these dates then Execute the results, they are non the wiser it is only when looking at the current seletions that the filter for the action is not met. Any ideas on how to warn users that their conditions are not valid?
