Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have the following question. I have a list of actions of which some have a due date and others dont.
Now I managed to get it working with below mentioned script, the problem is that where there is no due date he also gives 'overdue', which makes sense but not sure what and how to add a "if there is no due date mention 'x'" function.
Thanks for any support on this!
Example:
Overdue:
Load
Action_Date_Due,
if(Today() > [Action_Date_Due], 'Overdue', 'OnTime') as [Action_Overdue]
Resident Actions3;
How about?
If(Len(Trim([Action_Date_Due])) > 0, If(Today() > [Action_Date_Due], 'Overdue', 'OnTime'), 'N/A') as [Action_Overdue]
How about?
If(Len(Trim([Action_Date_Due])) > 0, If(Today() > [Action_Date_Due], 'Overdue', 'OnTime'), 'N/A') as [Action_Overdue]
Hi Miquel,
Yes, it works! thanks for your support, very much appreciated!!