I am using the following function and it is working! Now, I need to use it in another query for two different date fields TerminationDate and PeriodToDate. I tried to copy it and call it GetMonths360A and change the date fields, but it seemed to mess up the original function/query so I am asking for advice on how to accomplish this. Thanks.
Public Function GetMonths360(TimesheetDate As Date, ReleaseDate As Date)
GetMonths360 = ((Year([TimesheetDate]) - Year([ReleaseDate])) - 1) * 360 + ((12 - Month([ReleaseDate])) * 30) + (30 - Day([ReleaseDate])) + ((Month([TimesheetDate]) - 1) * 30) + (Day([TimesheetDate]))
GetMonths360 = -Int(-GetMonths360 / 30)
End Function