I typically run reports from Saturday AM to Friday PM and need to always display the 'week ending' date as the Friday of the week. If the report is always run on a Friday, I can just use the "TO" date as the week ending date and feel confident that it will be a Friday.
Example: Report 9/9/06 to 9/15/06. Week End date = Fri 9/15/06.
If no data is found on Friday, however, my stupid report ends on Thursday. The data is still considered week ending 9/15.
Given any date, how do I find the date that was Friday of that week and display it as the week ending date?
Example: Report 9/9/06 to 9/15/06. Week End date = Fri 9/15/06.
If no data is found on Friday, however, my stupid report ends on Thursday. The data is still considered week ending 9/15.
Given any date, how do I find the date that was Friday of that week and display it as the week ending date?