Does anyone know how to create a dynamic date table using a min/max date values from another table?
Does the below give you the expected outcome?
Thank you for your response. Using the example you provided I will do my best to express what I am looking for.
What I am looking for is for Table 11 to generate consecutive dates/rows using the Min. date from Table 10 | Start D (9/1) and end at Max. Table 10 | EndD (9/30).
It should generate/add 30 rows automatically for Table 11 where column FirstStartD will have 30 consecutive dates starting 9/1 and ending 9/30. Does that make sense?
Please study the below post, that generates what you are looking for:
Credits to @Paul_Danyliuk
Thanks a bunch! This is what I was looking for.
Have a great day!