Overdue actions vs script

[jeroenlansberge]

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;

[Miguel_Angel_Baeyens · Accepted solution]

How about?

If(Len(Trim([Action_Date_Due])) > 0, If(Today() > [Action_Date_Due], 'Overdue', 'OnTime'), 'N/A') as [Action_Overdue]

[jeroenlansberge]

Hi Miquel,

Yes, it works! thanks for your support, very much appreciated!!