To Create consecutive date time

[Ronal_bal]

Hi, 

I need to create consecutive days until it reaches in the field sequence of days 70 by taking the date equivalent to day 1 as base date.

I need to restart the process again when the sequence of days is 1 

attached is the screenshot

[Ronal_bal]

Thanks for providing the package, But I can't use the latest version of Alteryx. Can you provide me the screenshot?


I don't want to have null values after 70. because I need to do the same process for other samples containing 1 to 70 consecutive days.


Every sample has sequence from 1 to 70. not more than that.

[Adrian_T · Accepted solution]

@Ronal_bal In that case, then this simple multi-row formula should work. Image below: