CharlesDulaney
11 months agoQrew Trainee
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 of 1 JAN YYYY in the parent table record date field.
The parent record creation triggers another pipeline to populate the related child table [week_ending_dates] with every Sunday's date for that year. One date, one record.
Well, that's where it ends for me....
I am seeking some insight into creating the pipeline loop that creates each Sunday's date, as a record for the parent year. Seeking full automation and trying to avoid any table imports or manual work.
------------------------------
v/r,
Chuck
------------------------------