getting a record thet is between 2 dates

Question

User3837996 posted

het guys

my employer wants to have a form that gets you the expenses between 2 dates.

i have looked a lot on the internet but i couldn't find anything that could solve my problem.

because the problem is that the 2 dates only have a specified month and year and both are in a different field.

could you guys please help me?

Answer 1

User-1716253493 posted

SELECT * FROM YOURTABLE WHERE DATEFIELD BETWEEN @START AND @FINIST

Answer 2

User3837996 posted

that i know.

but how to be able to only need to specify year and month that come from 2 different date fields

Answer 3

User143067745 posted

Try  it:

select Fields
from TableName
where (select [MM/YYYY] = right(convert(varchar(10),Date_Field_In_TABLE,103),7))
between (select [MM/YYYY] = right(convert(varchar(10),StartDate,103),7)) and (select [MM/YYYY] = right(convert(varchar(10),ENDDATE,103),7))

Note: StartDate , ENDDATE  can have formate of dd/MM/yyyy or MM/yyyy doesn't matter.

Answer 4

User-1716253493 posted
where year(datefield)=@Year and Month(datefield )=@Month

Answer 5

User3837996 posted

thanks