1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| Public Function CalcAge(vDate1 As Date, vdate2 As Date, vRet As Integer)
' Comments : Calculer l'age d'une personne
' Paramètres:
' vDate1 - Date de Fête
' vDate2 - Date de comparaison
' vRet - 1 Année
' 2 Année , Mois
' 3 Année, Mois, Jour
Dim vMonths As Integer
Dim vDays As Integer
Dim vYears As Integer
vMonths = DateDiff("m", vDate1, vdate2)
vDays = DateDiff("d", DateAdd("m", vMonths, vDate1), vdate2)
If vDays < 0 Then
vMonths = vMonths - 1
vDays = DateDiff("d", DateAdd("m", vMonths, vDate1), vdate2)
End If
vYears = vMonths \ 12
vMonths = vMonths Mod 12
Select Case vRet
Case 1
CalcAge = vYears & " ans."
Case 2
CalcAge = vYears & " ans, " & vMonths & " mois."
Case 3
CalcAge = vYears & " ans, " & vMonths & " mois, " & vDays & " Jours."
End Select
End Function |
Partager