My current program gets all data based on the default date (in my case, the previous day's date, such that if today is 7/2, the program would get all daily movement data based on 7/1.)
However, say the program is ran on a Monday. The program has to be smart enough to not get data for sunday, of which there would be none. It would have to get friday's daily movement data. How do we get the previous billing date?
Also, say a week has a holiday. In that case, we would needed data from Friday and Saturday, if the report was executed on monday.
All responses will be appreciated and rewarded.