5 Replies Latest reply: Aug 21, 2017 5:58 AM by Peter Cammaert RSS

    Limit results in a new field in my script

    Kristina Crowther

      HI

       

      I have added a new field in my script  (days_overdue) , I wanting to limit the results so that it only show number of days over '0'.

       

      This is my script so far:

       

       

      LOAD [Person Ref],

           [Child Name],

           DoB,

           Gender,

           Ethnicity,

           Disability,

           [Legal Status],

           [Lead Professional],

           Team,

           [Start Date],

           [End Date],

           [Target Date],

           [Target Date Amended?],

           [Due Within 5 Days?],

           num(today()-[Target Date]) as days_overdue,

           Overdue?

      FROM