Evaluating a generated date as part of load script?
I am calculating a date based on 2 values being passed into load script below:
AddMonths ([Sub_Contract_Start_Date],[Sub_Contract_Term]) as [Sub_Contract_End_Date]
What I want to also do is identify any of the dates I create as part of the load which are within the next 30 days i.e. the date created which is named Sub_Contract_End_Date and give them an indicator e.g. contract expiring in next 30 days.
Is it possible to do this within the same load script or do I need to create a resident table to do the calculation?
I was thinking extending the expression with an IF statement but wasnt sure whether that was possible.