Generate Rows is not generating all rows for dates

[wonka1234]

Hi,

when trying to generate rows for dates, before I use the tool I have dates for 2023-12-25, but afterwards only 1.

Ie Date for louis Stevens  has 2013-12-25 before generate rows but its missing afterwords.

please see attached workflow.

[FrederikE]

Hey @wonka1234,

I think this happens because your end date is earlier then your start date: 

[wonka1234]

@FrederikE  I see.. I am using a multi row formula before this to get my end date..

IIF(isNull([Row+1:date]),DateTimeTrim([date],'LastOfMonth'),DateTimeAdd([Row+1:date],-1,'day'))

I wonder if this is causing the issue.

[binuacs]

@wonka1234 Seems to be a data issue, are you expecting End Date as 2023-01-01 in that row? Should it be 2023-12-31?

[wonka1234]

@binuacs   yes the last date should be 2023-12-31 actually. I think my formula above could be causing it.

[wonka1234]

@binuacs  any way i can solve this?

[binuacs]

@wonka1234 @Would you be able to provide the input file and expected output result?

[geraldo]

@wonka1234 

IIF(isNull([Row+1:date] ) or [Staff Name] != [Row+1:Staff Name],DateTimeTrim([date],'LastOfMonth'),DateTimeAdd([Row+1:date],-1,'day'))

replied in another post