Date format on Report

[tamer64]

Hello everyone,

I have a report which employees use to view previous day statistics information.

At the top of the report I have an unbound textbox which its control source is "=Date()-1". This works great except if the day is a Monday.

Is there a way I can format the unbound text box to say if the date equals Monday subtract 2 days so it would show Fridays date instead of Sunday.

 

[SkipVought]

hi,
[tt]
=Date()-iif(format(Date(),'ddd')='Mon',3,1)
[/tt]

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[tamer64]

Thank You Skip, I will try that try...Have a great weekend.