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 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.
@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?
@binuacs yes the last date should be 2023-12-31 actually. I think my formula above could be causing it.
@binuacs any way i can solve this?
@wonka1234 @Would you be able to provide the input file and expected output result?
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