How to scaffold dates in ALTERYX

In a text input with the first date being in one column and the end date being within another.

Later you must create the rows using generate rows

Within a new column being generated called Scaffold Date, the initial value is the first date. Then you increment it using loop expression box with the date adding by the metric you want (day, month or year). Then specify the end date as the second date within your text input.

Author:
Joel Akaje-Macauley
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab