I'm working on an invoice type report in Crystal Reports and the top of the report needs to have "Billing Period: Sunday's Date - Saturday's Date" with the dates being for the week we are billing.
I found a formula that pulls the dates for the previous week:
CStr(Minimum(LastFullWeek)) + "-"+ CStr(Maximum(LastFullWeek))
which works great but it pulls the dates based on the date the report is pulled.
Do you know how I can pull the last full week dates using a specific date field from within my database rather than the date I'm pulling the report?
Thank you, in advance, for any help you may be able to provide.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!