9 Replies Latest reply: Jan 21, 2015 1:50 PM by Ashwani Kumar RSS

    Set Expression Date Comparisons

    Robyn Brooker

      I have a set expression that works correctly as follows:

       

      =NUM(sum( {$<CurrentHRStatus={'Hired (*' },
      CurrentReqStatus={0,5},
      ReqFormTypeID_orig={29,384},
      WorkType1-={'*Intern*'},
      US_PositionStatus2-={'NO_POSITION'}>} Flag_HRStatus),'###')

       

       

       

       

       

      However, when I add ActionDate <= WeekEnd the expression does not work?  How can I get this to work for ActionDate <= WeekEnd ?  Note that WeekEnd is a field and not a variable.

       

       

       

      =NUM(sum( {$<CurrentHRStatus={'Hired (*' },
      ActionDate={"< =WeekEnd"},
      CurrentReqStatus={0,5},
      ReqFormTypeID_orig={29,384},
      WorkType1-={'*Intern*'},
      US_PositionStatus2-={'NO_POSITION'}>} Flag_HRStatus),'###')

       

       

       

       

       

       

       

       

      Please advise as soon as possible. Thank You!