What I’m trying to do
I’m trying to show a relative date within my notes properties.
So for example if I have a “Due Date” property set as today’s date, a text property below shows “Today”.
I’d also like to achieve this for “In X days” or “X days overdue” etc.
I have the two properties “Due Date” and “Due”.
Due Date is set as a standard date property.
Due is set as a text property.
I’ve then linked Due to a new field setting in Metadata Menu with formula as the field type. Its just what formula to achieve this is where I’d stuck.
Things I have tried
I’ve tried adjusting some formulas i’m using for other solutions, but no joy. Dataview is not my strong point and I need some help on finding the correct way to do it. Any help would be greatly appreciate.