Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Hello all,I would like to generate a result based on a certain date filter. I tried the following code but that did not work. Could anyone please assist. Your help is very much appreciated.
WITH MEMBER [Time].[Date].[blnDate]AS ( IIF([Time].[Date] < '2007-01-01', true, false))SELECT [Measures].[NumberOfConsignments] ON COLUMNSFROM [RevenueDataMart]WHERE ([Time].[Date].[blnDate])