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
"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
------------------------------