Query to get list of month and year between startdate and enddate

Use < and > keyword and get the records you want from start date till end date

select * from MyAccessTable where startdate is >= '5/31/2020' and enddate is <= '08/25/2020'

+1

I have created the function to retrieve all the dates between the starting and ending date and return the values.

Create Function Getting_Dates (@StartDate Datetime, @EndDate Datetime) returns @List table(Date Datetime)

As

Begin

Declare @BeginDate Datetime;

Set @BeginDate = @StartDate;

While @BeginDate<=@EndDate

Begin

Insert into @List Values(@BeginDate);

Set @BeginDate =Dateadd(D,1,@BeginDate);

End

Return;

End

If I pass this query after creating this function -Select * from Getting_Dates('01-Nov-2021','05-Nov-2021')

Output:

+1

It May help you if you want to get list of month and year as in blog:

https://www.c-sharpcorner.com/UploadFile/ff2f08/get-months-name-between-date-ranges-with-sql-query/

+1