Generate Month and Year until the end of the RecondID

[tchakir]

I have attached data that have Record ID, Value Month and Year. The first row of data start with April. I need to generate down months and year. For example file 2 should say May 2025 and when it get to October the year need to change to the following year like in line 7 should have October 2026 and Line 8 November 2026. Can some one help me with this workflow? 

Thank you 

[BransonJamesFarley]

Hey Tchakir,

Would something like this work for you? Attached is something I just worked on that hopefully will solve your issue. Let me know :).

[BransonJamesFarley]

You will just need to unselect the fields that aren't relevant to you ([DateTime_Out], [Hardcoded Date]).

[tchakir]

Thank you for your help. does it possible to make it not just from April? the workflow that i have before i can filter to any other month and it should specify from the first row what is the first month that it needs to start  in this case i don't have to change manually each time from what month it needs to start counting down. As well if you look at my final example the following year needs to be start with October instead of January. Please let me know how can i implement those speciation's. Thank you very much 

[tchakir]

The workflow needs to be dynamic  because i will be adding Interface tools that will be asking the end using what month to start  calculation. Unfortunately our financial year is Oct to Sep therefor the following year needs to be start with October.  Thank you 

[Qiu]

@tchakir 
I made a minor change to the flow of @BransonJamesFarley to match with your output data.
But I do wonder October, 2026 (calendar) should be of year 2026, not year 2027 as in your output data?

[tchakir]

Thank you very much for your help it look very good. The only questions can the Month be dynamic as i mention before my end using will be selecting what month to start counting down. What formula it can be use to take month from the first line item. in this case i don't have to change manually first formula tool IF !IsNull(Month) THEN '04/01/25' Else '' ENDIF

[Qiu]

@tchakir 
Sorry for not fully understanding the issue here.

Now I have used DateTimeParse to get the start date without HardCoding.

[tchakir]

Thank you very much for your help this is truly amazing :) 

[Qiu]

@tchakir 
Glad to be any help.