Hi
Can anyone help me construct an overdue date field? I have a todays date field and a date due field. I want to calculate the number of days past the date due calculated from todays date – if that makes sense. Leo sent me a template a while ago but it was in Dutch and I am struggling!
Cheers…
Tony,
you need two fields
1. date of the bill
2. number of days when the bill is overdue
then create a calculation field with this calculation
($now- [date of bill]
)/(24*60*60)- [number of days wen overdue]
that’s it. This way you can set the term over overdue automatic to the number of days or set it manually to a different term.
When the bill is overdue you get a positive result in the calculation date. Set a filer to this calculation field
calculation field > 0 and you filter all overdue bills
hope this makes sense
Hi Leo
many thanks… I dont have a field that calculates how many days overdue the todo is. How do I set this up. Below is what I have..
Cheers!
Date created = when the entry was created
Todays date = todays date
Set due date = date todo is due for completion
What I want to do is calculate from todays date how many days the todo has left for completion – a -figure if completion date is earlier than todays date, or a +figure if completion date is later than todays date. Also the todays date field does not auto populate even though I have the todays date field set to ‘set current date’ and for this to work it needs to auto populate each time the todays date changes!
Can you help? Cheers again!!!
Attachments:
You must be
logged in to view attached files.
I didn’t see your screenshots (made this after reading the email)
but I think you mean something like this.
The todays date is recalculated every time recalculation is made. The due date is set by you.
de due/ overdue shows the number of days due or overdue (overdue is accented)
Leo
see TFarc
Attachments:
You must be
logged in to view attached files.
In your setting, I think you only have to set the todays date to a calculated field with the calculation now() in it.
.
