Generate a list of dates

[SamThomas]

Hi

I am looking to generate a column of data named 'Date' (or anything) with the starting date being today()-1826 days and for each new row to incrementally +1 day until it reaches today's date. So I then have a column of data with 1826 dates, from 5 years ago to todays date. 

I just need to be able to create this out of 'thin air' essentially. I don't have another column to use. I need Alteryx to generate it. 

I have tried and tried using the generate rows tool, but can't seem to crack it. Any help would be gratefully received. 

Thanks. 

[BS_THE_ANALYST · Accepted solution]

@SamThomas You can use the Generate Rows tool for this:

[SamThomas]

Thanks a lot. Annoyingly I was so close! Missed the column name in the Loop Expression. Really appreciate that. 

[BS_THE_ANALYST]

@SamThomas ahh no way! I've done that more times than I'd like to admit 😂.