Hi
I am setting up a ‘ToDo’ form. I have a due date field. For the life of me I can’t work out how to create an ‘Overdue” field.
e.g. Due Date = 3rd August, today’s date 4th August, how do I show the task is one day overdue. Can anyone help?
Cheers
Tony
Tony,
here is a template with the setting you want.
It’s in Dutch.
But the fields in red are the ones you need (and off course the date fields and the Term: Betaaltermijn.)
in short:
the field Aantal dagen over shows the number of days overdue. A negative value means that payment is still in term. a positive field means the number of days overdue.
From her You can make a filter:
Aantal dagen = > 0
Remember TF5 does not auto calculate but you have to do that manually.
Leo
Attachments:
You must be
logged in to view attached files.