[SOLVED]Struggling with If then Else Date
I can't believe i'm struggling over something that looks so simple but :banghead::banghead::banghead:
where strSQL is a query that pulls todays date 5/30/2019
when I run this I get the "not today" when technically it should be "today" as the message correct? when I put ?Date in the immediate box I also get today's date.
I can't believe i'm struggling over something that looks so simple but :banghead::banghead::banghead:
Code:
Function Check_BA_Local()
strSQL = qry_ChkDate
If strSQL = Date Then
MsgBox "works"
Else
MsgBox "not today"
End If
End Function
when I run this I get the "not today" when technically it should be "today" as the message correct? when I put ?Date in the immediate box I also get today's date.
Last edited: