This tutorial will walk you through how to build a date table from scratch. In two simple steps, you will have a fully functional SQL table to use for any date based reporting you need.
Create Table Script:
https://github.com/ProfessorPitch/ProfessorPitch/blob/master/SQL/Dates/Date%20Table%20Creation.sql
Table Insert:
https://github.com/ProfessorPitch/ProfessorPitch/blob/master/SQL/Dates/Date%20Table%20Insert.sql
Source:
https://www.codeproject.com/Articles/647950/Create-and-Populate-Date-Dimension-for-Data-Wareho