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,