How to create a dynamic date table?

Does anyone know how to create a dynamic date table using a min/max date values from another table?

Dear @Edward_Davila

Does the below give you the expected outcome?

Hello Jean,

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?

Dear @Edward_Davila,

Please study the below post, that generates what you are looking for:

Credits to @Paul_Danyliuk

1 Like


Thanks a bunch! This is what I was looking for.

Have a great day!

1 Like