Generate Dates Function

[Tim6]

Hi There,

I am using the generate dates function to generate dates based on the start date and the end date.

Please see formula. 

Initialization Expression: [Start Date ]

Condition Expression: DateTimeAdd([Generated Date ], 1, 'day') <= [end date]

loop expression: DateTimeAdd([Generated Date ], 1, 'day')

Issue: I noted that the dates generated always stop 2 days before the actual end date. would anybody be able to help out with this? 

Thank you,

[MarqueeCrew]

@Tim6 ,

 make it easy on yourself and use our CReW macro:  https://gallery.alteryx.com/#!app/Generate-Date-Rows/5e31f42a826fd30ffcbf2c14  

cheers,

 mark

[christine_assaad · Accepted solution]

Hi @Tim6 

Please try for the Condition Express to have:

[Generated Date ] <= [end date]?