Reporting Services Remove Time from DateTime in Expression

Question

I'm trying to populate an expression (default value of a parameter) with an explicit time. How do I remove the time from the the "now" function?

Accepted Answer

Found the solution from here

This gets the last second of the previous day:

```
DateAdd("s",-1,DateAdd("d",1,Today())
```

This returns the last second of the previous week:

```
=dateadd("d", -Weekday(Now), (DateAdd("s",-1,DateAdd("d",1,Today()))))
```

Solution