Metadata menu formula to show relative date, "Today", "In 3 Days" etc

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.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.