# Thread: How to Calculate Rental Period? (A2k (9.0.4402) SR-1)

1. ## How to Calculate Rental Period? (A2k (9.0.4402) SR-1)

How to Calculate Rental Period?

A2k (9.0.4402) SR-1

I

2. ## Re: How to Calculate Rental Period? (A2k (9.0.4402) SR-1)

Hey John,

I don't always have the most elegant solutions, but try this..............................

Assuming the date of the agreement is named "testdate" the agreement fields would be:

AgreementStDate=testdate+1
AgreementEndDate=CVDate(DatePart("m",[testdate]) & "/" & DatePart("d",[testdate]) & "/" & (DatePart("yyyy",[testdate])+2))

Both fields should have their format set to the appropriate Long Date, Short Date, whatever.

Hope that helps!
Kathi

3. ## Re: How to Calculate Rental Period? (A2k (9.0.4402) SR-1)

Hi John,
You could use:
Hope that helps.

4. ## Re: How to Calculate Rental Period? (A2k (9.0.4402) SR-1)

Thanks Kath & Rory

That's what I like about Microsoft, many ways to do the same thing, another solution for your bag of tricks:

From: ([ExpireDate] + 1)