Limit results in a new field in my script

[#1]

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

[Anil_Babu_Samineni]

You could arrange all date formats is same. Then only it works. Even, Don't require to use Num() here

[vishsaggi]

May be this? Do a preceding load.

LOAD *

WHERE days_overdue > 0;

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

FROM YoursourceTable;

[Peter_Cammaert · Accepted solution]

I guess you don't want to know about invoices that aren't overdue in a field that shows the number of days overdue? Then you could use a minor expression modification that removes all negative days_overdue values:

:

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

:

Best,

Peter

[#5]

Thank you everyone who has replied to me, my script now works.

Thanks again

[Peter_Cammaert]

If your problem has been solved, please close the discussion by marking reponses as HelpFul and Correct. That way, other community members will know that there is a solution to be found here to a problem they may have encountered themselves.

Thanks.