Help With Date Calculation Function

Hi Everyone,

I have been working on a function to calculate the number of months between two dates. I am now stuck as I am new to functions as well as VB2008.

There is one value I want to input: dueDate
There is one value I want to output at the end: debtMonths

Can anyone see if I am going along the right lines and also how I can finish this off by using the function in a Macro.

If I need to provide any more info please let me know.

Thanks
dvent

Please Login or Register  to view this content.

I assume you are not familiar with teh DateDiff VBA function (or the DATEDIF worksheet function for that matter)?

Please Login or Register  to view this content.

HTH

Jason

Thanks Roy,

I have amended the function slightly as VB2008 came up with some errors (obviously I am not using Excel for this).

Please Login or Register  to view this content.

My final MsgBox gives the difference between EndDate and BeginDate like I need.

Can anyone tell me now how I can use this function within my macro below:

Please Login or Register  to view this content.

What I am trying to say is if i declare an object of:

Please Login or Register  to view this content.

How do I assign the value of calculateMonths to this?

Thanks again
dvent

I am using Microsoft Visual Basic 2008 Express Edition.

Now that I have this function I want to be able to use it in a Macro/Class/???. I am not sure what it'll be called?

It is a Windows Form I am producing. I am trying to assign the result from

Please Login or Register  to view this content.

to an object of CreditCard1Months. But I am stuck.

Ah I've cracked it:

Please Login or Register  to view this content.