Calculating Overdue...

[leocattqv]

Hello,

this is really stumping me.

I want to show based on a calculation of On Time <= <Date> + 30, and Overdue > <Date> + 30

Can I get a bit of direction here please

thanks,

-L

[MarcoWedel]

LOAD DateToCompare,

          If(DateToCompare <= Date+30, 'On Time', 'Overdue') as [On Time]

FROM yoursource;