If you have a multiselect parameter but you would like to have the “None” option added to it here is how you can accomplish it.……
In order to check is a Date is the same as today use the following code: DATEDIFF(d, SOMEDATE, GETDATE()) = 0 Tweet Tweet
Here is how you get the 00:00:00 timestamp for GETDATE() or any other date: SELECT DATEADD(d, DATEDIFF(d, 0 , DATEADD(d, 1, GETDATE())),0) Tweet Tweet