Manipulating date and time on Reporting services filters

Posted on 2018-11-20 | by johniax

=Format(NOW,"yyyy-MM-dd") & " 07:00:00"                   # today 07:00:00
=Format(DateAdd("d", -1, NOW),"yyyy-MM-dd") & " 07:00:00" # yesterday 07:00:00
=FORMAT(DateAdd("d",-1,Today()), "yyyy-MM-dd 07:00:00")   # yesterday 07:00:00