5 Replies Latest reply: May 27, 2011 12:09 PM by Georgina Spary RSS

    Set analysis expression syntax

    Georgina Spary

      Hi folks - I hope you can help me

      In my table showing counts of applications to date, I want to add another showing applications up to same day last year

       

      I've created a variable v_LastAppYear, as  Daystart(AddMonths([DM_Refresh_Date], -12)) works fine in a text box and displays

      27/05/2010 00:00:00

      My application dates are of the form

      09/12/2009 00:00:00

      which looks identical to me

       

      My syntax is

      =Count ({< [Application Date]= {$(='< v_LastAppYear')} >} Application) 

      which quite obviously doesn't work because (I'm guessing) I need to qualify the date. But with what? and how?

       

      Thanks

       

      George