The DateDiff function is a VBA function. I am using it in a user form to calculate the number. I have to multiply the months and days a payment is late by .01 in order to calculate a penalty. So if the last month had 31 days it would read 3.97 months.
I am trying to calculate the amount months and days between to dates. The DateDiff function will give me the number of months or the number of days but not months and days. Is there a function in VBA or VB that does this?
On our computers we had version 7 and bought the upgrade to 8 then 8.5. We I installed it on my machines that is the way I had to install it to get 8.5 to work. I do not know if all of the CR7 files were replaced or not.
Also the programmer who was working on this project before me left the CR...
I have a program written in Visual Basic 6, accessing an Access 97 database using aODBC connection. The program originally used a Crystal 7 report for output. We upgraded from CR7 to 8.5.
We added a Crystal report viewer and Crystal 8.5 to the Visual Basic program and I am trying to repackage...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.