Option Compare Database
Option Explicit
Public Function DansPeriode(UneDate As Date) As Boolean
If UneDate >= DateSerial(Year(UneDate), 12, 20) And UneDate <= DateSerial(Year(UneDate) + 1, 1, 10) Then
DansPeriode = True
Exit Function
End If
If UneDate >= DateSerial(Year(UneDate), 3, 20) And UneDate <= DateSerial(Year(UneDate), 4, 10) Then
DansPeriode = True
Exit Function
End If
If UneDate >= DateSerial(Year(UneDate), 6, 20) And UneDate <= DateSerial(Year(UneDate), 7, 10) Then
DansPeriode = True
Exit Function
End If
If UneDate >= DateSerial(Year(UneDate), 9, 20) And UneDate <= DateSerial(Year(UneDate), 10, 10) Then
DansPeriode = True
Exit Function
End If
End Function
Partager