Page 1 of 1

Dates to Days

PostPosted: Sat Feb 19, 2005 7:13 pm
by ajphoto
HI,

There's a calc I've been wrestling with for months. Figuring prorated taxes for Real estate. I'd like to be able to enter two dates dd/mm/yyyy, even over multiple years, and have filemaker 7 return the total number of days inclusive. That way I can multiply by a day rate or divide by taxes paid to find the day rate.

If this is within the realm of possiblilties Please help.

Thanx
AJ

PostPosted: Sun Feb 20, 2005 8:57 am
by John Sindelar
Maybe I'm missing something, but given two date fields the number of dates (inclusive) between them is:
Date2-Date1+1