Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    How to Calculate Rental Period?

    A2k (9.0.4402) SR-1

    I

  2. #2
    Star Lounger
    Join Date
    Mar 2002
    Location
    Decatur, AL
    Posts
    53
    Thanks
    2
    Thanked 0 Times in 0 Posts

    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. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

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

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

    Microsoft MVP - Excel

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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)

    To: DateAdd("m", 24, [ExpireDate])

    I learned alot from this rookie question.

    John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •