MS Access Age Calculations Years/Months/Days By Details in Bangla | Ahsan Tech Tips

MS Access Age Calculations Years/Months/Days By Details in Bangla | Ahsan Tech Tips

 

In this MS Access Bangla tutorial, we will learn how to calculate age function years, months and days by details in bangla by Ahsan Tech Tips 

 Code:

Public Function CalcAge(DOB As Date) As String

Dim intYears As Integer, intMonths As Integer, intDays As Integer

  intMonths = DateDiff("m", DOB, Date)

  intDays = DateDiff("d", DateAdd("m", intMonths, DOB), Date)

  If intDays < 0 Then

    intMonths = intMonths - 1

    intDays = DateDiff("d", DateAdd("m", intMonths, DOB), Date)

  End If

  intYears = intMonths \ 12

  intMonths = intMonths Mod 12

  CalcAge = intYears & " Years and " & intMonths & " Months And " & intDays

& " Days"

End Function

  Video: