PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Public Sub convertNumMonthsToYearsandMonths(passedNumberOfMonths As Long, _ returnYearStr As String, _ returnMonthsStr As String) 'round Dim wkYears As Double Dim wkYearsInt As Long Dim wkMonths As Long ' If passedNumberOfMonths < 12 Then wkYears = 0 Else wkYears = Round(passedNumberOfMonths / 12, 2) End If wkYearsInt = CInt(wkYears) ' wkMonths = passedNumberOfMonths - (wkYearsInt * 12) ' returnYearStr = Trim(Str(wkYearsInt)) returnMonthsStr = Trim(Str(wkMonths)) ' End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Macro/VBA to send email based on criteria being met from form||1||40|
|Linking Child/Parent fields between 2 subforms||15||31|
|What is the VBA syntax for Refreshing the form in the After Update event of one of its controls ?||11||44|
|How can I set my Access Query up to filter out specific records||13||28|