Date - Current Month and Previous Month.

Question

Hi All,

Firstly i have the consolidated data.

Secondly assuming that i run the flow on the 1s of June 2021.

( my current Report Month would be - 31-05-2021) and ( previous reporting Month - 30-04-2021).

I want to do lots of comparison against current reporting month (31-05-2021) and Previous reporting month(30-04-2021)

like evaluating many scenarios

how many ID have carried over from last month -(30-04-2021) to current month (31-05-2021).
how many new ID have come in current month (31-05-2021).
how many ID have left current month (31-05-2021) that was there in previous month and so on.
How many ids have changed the status from OPEN TO CLOSED and so on

I want split the data into two streams one for current month and one for Previous month and

wanted this to be dynamic so that when we added new data which 31-06-2020 the flow has to be dynamic to say that 31-06-2020 is my current reporting month and 31-05-2020 is my previous reporting month.

Thanks

Current & Previous MOnth Column.yxmd

mceleavey · Accepted Answer

Hi @suby ,

You can calculate the last day of the prior month to represent your current month, and the last day of the month prior to last to act as your prior month by using the following calculations:

I built these in a formula tool. The first calculates the date using the relativity to datetimetoday() and the second is built on that calculated field, therefore these are now dynamic.

Hope this helps,

M.