Engine.IterationNumber not working in DateTimeAdd function within formula tool

[SgdPackard810]

Hello,

I am attempting to practice building an iterative macro that will simply return all the dates of the year 2019. However, it looks like the Engine.IterationNumber variable inserted into my DateTimeAdd Function in the formula tool is not having the intended effect of increasing the "FromDate" column by 1 day before looping back around.

Any ideas would be greatly appreciated!

[grossal · Accepted solution]

Hi @SgdPackard810,

you were pretty close to the actual solution, you only made one mistake: Your input doesn't match your output.

Input date format	Output date format
1/1/2020	2020-01-01

I removed the DateTime-Tools and formated the input dates in the Alteryx Date-Format and it works perfectly fine!

Fixed Macro attached. Let me know if it works for you!

Best

Alex

 

 

[SgdPackard810 · Accepted solution]

Thanks so much!