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.