Difference between two date fields

[carlingac]

Hi

I think im going to owe everyone thats helped me out a pint once i have finished this HNC project!!

Ok, another issue;

I have a date field on a form, which is an editable field, called "due_date".

What i would like to be able to do is show how many days the "due date" is overdue.

i.e if a call was due to be completed on the 16/03/05 and the current day was the 17/03/05 the call would be over due by 1 day.

If there a way i can find the difference between the date i have set and the current date and display it in a view?

Also on the same topic in my "due_dat" date/time field is there a way to to only show weekdays in the popup calendar?

many thanks once again

 

[carlingac]

worked it out by doing this:
(@Now - due_date) / 86400

however i would still like to be able to exclude weekends if possible.

many thanks