Create a Table of all Sundays within a Year
I have a parent table [year] and its child table is [week_ending_dates].
[year] ------------> [week_ending_dates]
A pipeline runs annually on 1 Jan of every year and creates the New Year's date o...
Forum Discussion
Are you opposed to just doing a one time import? You can drag down the next 10 years of Sundays in Excel and just pre-load them now instead of building the Pipeline / testing it / monitoring it.
You can just pre-load 5, 10, 15 years worth of data and if you don't want to see any of it just add a simple 'valid' checkbox to hide any futures you don't want and hide them via role security so that you don't have to worry about them being there they just re-appear when relevant.
------------------------------
Chayce Duncan
------------------------------
"You can just pre-load 5, 10, 15 years worth of data and if you don't want to see any of it just add a simple 'valid' checkbox to hide any futures you don't want and hide them via role security so that you don't have to worry about them being there they just re-appear when relevant."
Words of wisdom by @Chayce Duncan . I too have preloaded calendars for next 50 years , Clearn and simple
------------------------------
Prashant Maheshwari
------------------------------
agreed,
------------------------------
v/r,
Chuck
------------------------------
