20 Replies Latest reply: Jan 19, 2017 4:40 AM by Max Goldshtein RSS

    Help in date script

    Max Goldshtein

      Hi

       

      I would like to count on rows (SeriesUID) by the following conditions:

      (today date - validated date(column1))>7 and column2 is null

      This is my script:

      count({$<today.date-[Validated.autoCalendar.Date]>{7}>}SeriesUID) and

      count({$<Truther1={null}>}SeriesUID)

      I got an error in: set modifier expression

       

      I will be glad for help in the script.

      Thanks.

       

       

      Max