Is there a formula to determine the day of the week in Report Designer? (as in Sunday) I'm working on a LCR report to send weekly - my problem is the report isn't always run/sent on the same day each week. I need to determine the system date and subtract # of days to get back to our PE date - Sunday. I can get the report to work if we run the report on the same day each week, but ideally I would like the report to be flexible on the date run. Any suggestions?:
FYI - using My Assistant to run the reports and send. There may be a way in My Assistant that I don't know about.
Thanks in advance :)