14 Replies Latest reply on May 24, 2018 10:45 AM by Shinichiro Murakami

    Using date to determine filter

    Richard L

      I have a field called IterationPath.


      In it, I have selections like this that continue through the next year

      _Workforce_IT\S33 Apr 16 - Apr 27

      _Workforce_IT\S34 Apr 30 - May 11

      _Workforce_IT\S35 May 14 - May 25


      I'd like to look at todays date and if the date is between two given dates, then use a set string of text as the field selection.


      IF [GetDate] >= 05/14/2018 AND <= 05/25/2018 THEN [Iteration Path] = '_Workforce_IT\S35 May 14 - May 25'


      How might this be accomplished?


      Uploaded packaged workbook