I apologize for the stupidity of this question. What is the proper syntax in using the Date() function in VBA. I have a shipping form that I want to filter what shipped today.
In a query I know its simply =Date() - In VBA ; quotation marks etc. I'm a little foggy.
'Today Button filtering SH_ShipDate
Dim today As String
today = "SH_ShipDate = date()"
Me.Filter = today
Me.FilterOn = True
Thanks for your help