Formula for Dates 1

[PBS2]

I have two formulas on my report @FromDate and @ToDate. These two dates are the from/to date range for the report. The report always displays a weeks worth of data from the @FromDate (always a Sunday) to the @ToDate (always a Saturday).

If the @ToDate is a known date how can I calculate the @FromDate using the value of @ToDate.

 

[crystalvictim]

I don't know if I got you right:
You have a formula @ToDate that returns a date (alsways a Saturday) and are looking for a way to calculate the @FromDate (which is supposed to be always the Sunday before @ToDate) ?

You could try to use
{@ToDate}-6;
as calculation in your @FromDate formula - this should at least work with CR8.5.