Sql query with between, And command

Help Studio
, ,
1

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 activity

2

@rifnanahas Have you tried using the Expression in this way :
"select * from tablename where columnname BETWEEN “+FirstDate+” AND "+EndDate

3

when I tried this its showing an error in activity as "disallows implicit conversion from date to string

4

@rifnanahas Ok, What is the Datatype of Date in Datatable ?

5

Datetime

6

@rifnanahas Sorry, I meant Database :sweat_smile:

7

date itself

8

This link may help you,

9

@rifnanahas Is it possible for you to Convert Date type to String in Database?

10

No, I doesn’t have the right to convert

11

Maybe look into CAST?
I’m a little confused. If you need them to be strings then try something like:

SELECT
CAST(TableName.EndDate AS varchar),
CAST(TableName.FirstDate AS varchar)

and if you need them as datetime then the same thing but datetime instead of varchar.

12

varQuery = "select * from tablename where columnname BETWEEN "+ FirstDate.ToString("dd/MM/yyyy") +" AND "+ EndDate.ToString("dd/MM/yyyy")

2 Likes
13

@rifnanahas
Create argument in parameters property of execute query activity and pass that parameters in query with @variablename.
Same as we do in procedure in SQL server

1 Like