Date Calculation, expiration date of lease 
Author Message
 Date Calculation, expiration date of lease
Have date calculation for the expiration date of a lease.  Lease is dated
05/01/2001 and term of lease is for 18 months or maybe 20 months.  My
calculation:
Date(month(DateofLease),Day(DateofLease),Year(DateofLease)+(TermofLease)
This all works fine as long as the lease term is 1, 2, 3, years, etc., but does
not work for partial year term such as 6 months, 18 months, 1.5 years etc.
Thanks in advance for all help


Tue, 11 Nov 2003 00:22:07 GMT
 Date Calculation, expiration date of lease

Try adding the months:

Date(Month(DateofLease)+Month(DateofLease), Day(DateofLease),
Year(DateofLease))

--

John Weinshel
Datagrace
Associate Member, Filemaker Solutions Alliance
Vashon Island, WA
(206) 463-1634


Quote:
> Have date calculation for the expiration date of a lease.  Lease is dated
> 05/01/2001 and term of lease is for 18 months or maybe 20 months.  My
> calculation:
> Date(month(DateofLease),Day(DateofLease),Year(DateofLease)+(TermofLease)
> This all works fine as long as the lease term is 1, 2, 3, years, etc., but
does
> not work for partial year term such as 6 months, 18 months, 1.5 years etc.
> Thanks in advance for all help



Tue, 11 Nov 2003 01:05:56 GMT
 Date Calculation, expiration date of lease
Sorry--mis-wrote. Should be:

Date
(
   Month(DateofLease)+Months,
   Day(DateofLease),
   Year(DateofLease)
)

where "Months" is a number field=number of months, life of lease.
--

John Weinshel
Datagrace
Associate Member, Filemaker Solutions Alliance
Vashon Island, WA
(206) 463-1634


Quote:
> Try adding the months:

> Date(Month(DateofLease)+Month(DateofLease), Day(DateofLease),
> Year(DateofLease))

> --

> John Weinshel
> Datagrace
> Associate Member, Filemaker Solutions Alliance
> Vashon Island, WA
> (206) 463-1634



> > Have date calculation for the expiration date of a lease.  Lease is
dated
> > 05/01/2001 and term of lease is for 18 months or maybe 20 months.  My
> > calculation:
> > Date(month(DateofLease),Day(DateofLease),Year(DateofLease)+(TermofLease)
> > This all works fine as long as the lease term is 1, 2, 3, years, etc.,
but
> does
> > not work for partial year term such as 6 months, 18 months, 1.5 years
etc.
> > Thanks in advance for all help



Tue, 11 Nov 2003 01:08:35 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Date Calculations : Period Between 2 Dates (AGE) in Years, Months and Days

2. Date Calculations : Period Between 2 Dates (AGE) in Years, Months and Days

3. Date problem- date calculation in between values

4. ((Current Date - Start Date)/(End Date - Start Date))*Contract Amt

5. Automatic notification of approaching expiration dates

6. Subscribers expiration date ?

7. Problem with dump expiration dates

8. Dump default expiration date

9. Expiration date

10. Expiration date

11. Changing password expiration date

12. Expiration dates in FMPro


 
Powered by phpBB® Forum Software