Sairam

Sairam

  • NA
  • 321
  • 411.1k

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

Aug 27 2021 3:51 PM

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)