4 Replies Latest reply: Jul 15, 2016 4:21 AM by Phil Speight RSS

    Set Analysis Later Than Date But Less Than Today

    Phil Speight

      Hi

       

      I am trying to create a set analysis which returns data which is after 01/04/16, but less than todays date.

       

      I can get it to work for data after 01/04/16, but how do I include the Less than today.

       

      Here is my current script :

       

      =Count({<

      state={'Recruited'},

      [Booked start date]={'>=42461'}

      >} Applicationid)


      Any thoughts on how I can stop future dates pulling through?



      Thanks



      Phil