I have two varaible:StartD ate = Date
EndDate = DateAdd("d", 7, StartDate)
I'am using these to try to retrieve data from a table. What is the correct syntax to use variables of type "DATE" within the "WHERE" clause. I've been trying to use the "Between" option and "<= , =>" when comparing these dates to the DATE column on the table. If I put two actual dates in place of the variable names such as #1/1/2006# and #1/1/2007# it works I just can't get the variable names to work. Thanks, in advance.
EndDate = DateAdd("d", 7, StartDate)
I'am using these to try to retrieve data from a table. What is the correct syntax to use variables of type "DATE" within the "WHERE" clause. I've been trying to use the "Between" option and "<= , =>" when comparing these dates to the DATE column on the table. If I put two actual dates in place of the variable names such as #1/1/2006# and #1/1/2007# it works I just can't get the variable names to work. Thanks, in advance.
Comment