Forum Discussion
All of the above solutions worked, I was wondering if we could take this one step forwards with date segregation as below
(earlier it was as per end of the year, now its one year cycle, and also the diff between the start and end date should not be greater than 365/366 days considering leap years if possible )
Input :
ID StartDate EndDate
1 2016-05-12 2019-11-30
Output :
ID StartDate EndDate
1 2016-05-12 2016-11-30
1 2016-11-31 2017-11-30
1 2017-11-31 2018-11-30
1 2018-11-31 2019-11-30
this is how the contract management system would also be implemented.
Did you happen to find a way to offset specific number of rows?
- bojanvelevski3 years agoValued Contributor
If you know the exact row number where the Excel should start, than you can simply use a filter with the following expression:
snap.in.totalCount > (rowNumber)
Related Content
- 4 months ago
- 6 years ago
- 2 years ago