You might try something like this in a preceding load:
if(date#(contract_end_date)<=today(), 'contract ended', 'contract current') as contractStatus;
load * inline [
This example gives the following result
Thank you for this. I have tried to use the below, with no luck (it doesn't recognise anything as a 'contract ended', and thinks that everything in the app is 'contract current')
if(date#(contract_end_dt)<=today(), 'contract ended', 'contract current') as TenancyStatus,
Would this have been the way you would have written the formula using the "if" condition?
I have tried this, unfortunately it still hasn’t worked. It still recognises every customer as ‘contract current’, even though there are at least half that have a null value in the contract_end_dt field.
Is it because they are null values that this isn’t working?
Customer Insight Analyst
52 Regent Street
T: 0161 605 7921