Dates using generate rows

[Tim6]

Hi There, 

I want to generate dates using the generate rows tool. 

The initialization expression is [Start Date]

The condition expression is DateTimeAdd([Generated Date ], 1, 'day') <= '2020-04-02'

Loop Expression is DateTimeAdd([Generated Date ], 1, 'day')

But i would like to include a condition that no dates are generated after the date in the maturity column. 

would you be able to assist with this? 

Thank you, 

[Greg_Murray]

@Tim6,

I think conditional expression is the culprit here. I don't know that you need the datetimeadd() function in there. In the example below you can substitute end date for maturity date. 

[Tim6]

Hi Greg, I cant use the formula below because i need the dates to be generated up until April 2nd, however if the maturity date is before april 2nd then i want the dates to be generated until the maturity date. 

Is there something i can add to my initial formula to account for the maturity date ? 

Thank you

[AlanSchaeffer]

Hi,

I've just slightly changed the code that was given to you before.



Now, it will create date until the smallest date, whether it is the final date, in your case 2020-04-02 or the maturation date.
I hope this is clear and will help.
Alan

[Greg_Murray · Accepted solution]

Ok, I would just use an statement in a formula to figure out which date to use, for the sake of simplicity.