I have two date variables as FirstDate and EndDate select * from tablename where columnname BETWEEN ‘01/01/2020’ AND ‘31/01/2020’ instead of these two date,I want to enter the two date variables in the above query. can anyone help me with sql query which isto be used inside execute query activit…

Sql query with between, And command

Manish540 (Manish Shettigar) March 9, 2020, 6:59am 8

This link may help you,

Topic		Replies	Views
String constants must be in quote .Error Execute Query. Part II Activities database , activities , question , sql	7	2394	September 10, 2021
Using DateTime in Execute Query causes error Activities database , sql	0	1199	February 15, 2021
Trying to pass start date and end date variables into SQL query Studio datatable , excel , database , activities , question	11	9063	March 10, 2020
Cant using datetime in database query Community activities , studio , question , community	6	767	December 21, 2022
Insert a varibale coming from an excel in a query Studio question	11	197	January 8, 2024