Dynamic re-arrangement of column data

Question

Hi All,

I need help with dynamic re-arranging of data.

Example:

Start DateEnd DateJanuary 2020April 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.

DatesJanuary 2020February 2020March 2020April 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!

Emil_Kos · Answer

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.

Date Time rangev3.yxmd

mjh418 · Answer

@Emil_Kos

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.

Emil_Kos · Answer

Hi,

Please see amended workflow attachted.

Date Time rangev2.yxmd