|
|
Расчёт кол-ва дней до Дня Рождения (Сотрудника например) по Дате Рождения
Public Function ToBirthDayDays(vBirthDay As Variant, Optional iMinLimit% = 365) As Integer
Dim iYear As Integer
Dim iMonth As Integer
Dim iDay As Integer
Dim dBD_Date As Date
On Error GoTo ToBirthDayDays_Err
iYear = Year(Date)
iMonth = Month(vBirthDay)
iDay = Day(vBirthDay)
dBD_Date = DateSerial(iYear, iMonth, iDay)
If dBD_Date < Date Then
dBD_Date = DateSerial(iYear + 1, iMonth, iDay)
End If
iDay = DateDiff("d", Date, dBD_Date)
If iDay <= iMinLimit Then
ToBirthDayDays = iDay
End If
ToBirthDayDays_Bye:
Exit Function
ToBirthDayDays_Err:
ToBirthDayDays = -1
Err.Clear
Resume ToBirthDayDays_Bye
End Function
|
|