Datetime Validation

[DerPflug]

How can I verify that a datetime is within one day's difference of the current date and between 11pm and 2am?

 

[DerPflug]

I did this:

If DayDifference <= 1 Then
    If hour = 23 Or hour <= 2 Then
        IsValid = True
        If hour = 2 And min > 0 Then
           IsValid= False
        End If
    Else
       IsValid = False
    End If
Else
    IsValid = False
End If

 

[indrahig]

maybe this code could help:

daydifference = DateDiff("d", datevalue1, datevalue2)
hour = DatePart("h", datevalue1)
If daydifference <= 1 Then
If hour >= 23 Or hour <= 2 Then
IsValid = True
If hour = 2 And min > 0 Then
IsValid = False
End If
Else
IsValid = False
End If
Else
IsValid = False
End If