3
Answers

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

Sairam

Sairam

3y
794
1

I have table MyAccessTable, with columns like AccessID StartDate Enddate as fields

I want to separate it our each month in between startdate and enddate in the table.

For example Startdate is 05/31/2020 ,Enddate 08/25/2020 i have to get data of access information

AccessID StartDate  

1              05/01/2020 

2              06/01/2020

3              07/01/2020

4              08/01/2020

 

Answers (3)