Check for weekends V8.5

[tomk01]

Is there a way to display a date (friday) if the date falls on a weekend (Saturday)?

I have a dateTime field. If the date falles on a saturday i need the report to display the friday prior.

here is the formula I created that does not work:

stringvar checkdate := if {SCalendar.checkDate} = crsaturday then Checkdate = "Saturday Checkdate";

 

[kskid]

Since you did not specify how you wanted to display the date, I assumed DD/MM/YYYY

if DayofWeek({table.date}) = 7 then
   cstr(dateadd("d",-1,{table.date}),"MM/dd/yyyy")
else
   cstr({table.date},"MM/dd/yyyy")