Gasman
Enthusiastic Amateur
- Local time
- Today, 14:02
- Joined
- Sep 21, 2011
- Messages
- 14,042
Well I would expect that would work?, the syntax looks correct to me.?Dim strDate As String
Dim strSQL As String
strDate = Format(Me.txtAppointDate, strcJetDate)
strSQL = "SELECT * FROM tblAppointments WHERE tblAppointments.AppointDate > " & strDate
Debug.Print strSQL
SELECT * FROM tblAppointments WHERE tblAppointments.AppointDate > #08/08/2020#