MTD Expression on a single column - SSRS
- by Eric
I need a bit of help here.
I have been unable to create an 'Month To Date' expression to a single column on SSRS.
I tested the following expression from a similar question in the forum, but it gives me a squiggly line below the variable 'd'
=IIF(Fields!CreateDate.Value >= DateAdd(d,-7,Today()), Sum(Fields!Sales.Value), 0)
If I run it, of…