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

Topic

New Reply

How to Calculate Rental Period?

A2k (9.0.4402) SR-1

I

Reply | Quote

Replies

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

Reply | Quote

Hi John,
You could use:
DateAdd(“yyyy”,2,[datefieldname])-1
Hope that helps.

Reply | Quote

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)

To: DateAdd(“m”, 24, [ExpireDate])

I learned alot from this rookie question.

John

Reply | Quote