4 Replies Latest reply: Dec 24, 2015 12:25 PM by Spam Hackback RSS

    How to find count of events last year based on today's date

      Hi Experts,


      The title pretty much says it all.  I'm trying to write an expression that will return the count of events where [YearOccurred] = last year, but I need it to be based on the current date.  So right now it would return records where [YearOccurred] = 2014, but on Jan 1 it would return records for 2015.


      This isn't working.  Does anyone know if I'm close? 


      =Count( {1<Department={"Repair"},  Year = {"=YearAdd(Year(Today()),-1)"}>} DISTINCT VisitID) 


      Thanks in advance!