Parameter defaul to yesterday

[Cpreston]

Hi

We have a report that asks for 2 dates.

I am wondering if it is possible to run the report for Yesterdays date by default.

Any ideas how I can make the dates (or a date) default to yesterdays date.

Thanks

 

[BettyJ]

If report should run by default for yesterday's date, then you do not need to use a parameter. In the record selection formula, just use
[tt]{table.field}=currentdate-1[/tt].

 

[Cpreston]

Hi

Thanks for the reply. Also realised on a monday it needs to look at Friday, so trying to get it working with this

If Dayofweek = 1 then {datetimecreated} = CurrentDate-3
else {datetimecreated} = CurrentDate-1

Also just realised the report is using more complex dates than I thought so will have to rethink it all.

But I am sure your code and mine should work once I have the dates working how I would like

Thanks again