Here is the create table script for the date table

USE [proppaty_config]
GO
/****** Object:  StoredProcedure [COMMON_DATA].[POPULATE_DATE_TABLE]    Script Date: 16/08/2021 11:32:52 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER...

Thanks for your reply.

I played around with it and managed to get it working by using the following. Just added some IF clauses to it and set my offset before...