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.
October 10, 2008 8:06 PM
October 10, 2008 8:40 PM