Hi All,
I need help with dynamic re-arranging of data.
Example:
Start Date | End Date |
January 2020 | April 2020 |
I need this to Dynamically change into just 1 column consisting separate months like the expected outcome below. The date input will be different all the time. for example, sometimes the workflow will spit out Jan to June, sometimes Jan to December, sometimes February to August, sometimes more than a year, like Jan 2020 to March 2021.
Dates |
January 2020 |
February 2020 |
March 2020 |
April 2020 |
So the requirement is that it needs to start with the start date, end with end date, and have all the consecutive months in between. The simpler the workflow, the better. Assumption is that the input is not a manual input, it is a RESULT of a workflow. Also it cannot be a macro tool because this will be PART of a macro.
Thank you for your time!
Hi @mjh418,
I have created a workflow that will show you the month names for the respected time range:
Generate rows is a perfect tool to obtain this result.
Thank you so much, but can you please modify this so that it always gives me the LAST DAY of each month instead?
I'm sorry but can you assume that the input is not January 2020, but already in date format as the last day of the month? for example, 2020-01-31, 2020-02-29 etc.
somehow when i skip the parse to date tools, and apply everything else the same as you did, it gives me weird results.
Hi @mjh418,
I have amended the workflow for you:
It should work like you want it to work. Basically, I needed to create a row for each day of the month to be sure that we identified the last day of each month correctly.