Extract Month (mm) and increment by 1

[Zahid1 (Zahid)]

Hi All,

I am using excel file to read data in the below format .

While reading the Period, I need to increment the month by 1.
Eg : 09/18 to 10/18 and enter in my application.

There is a condition, in case of 12/18, my next period should be 01/19.

Any help would be appreciated. If someone can share xaml, it will be great.

[Palaniyappan (Forum Leader)]

try like this buddy @Zahid1
once after getting the date value from the excel with a variable named out_period of type string
out_period = “09/10” (make sure that you are getting in this format from excel or if the format changes we need to change the format accordingly while converting to datetime in the below conversion)
out_period_DT = Datetime.ParseExact(out_period,“MM/yy”,System.Globalization.CultureInfo.InvariantCulture)

where we have out_period_DT of type DateTime
to increment by one month
out_period_DT = out_period_DT.AddMonths(+1)

[Palaniyappan (Forum Leader)]

Here you go buddy a xaml @Zahid1
hope its resolved
month.zip (17.6 KB)
Kindly try this and let know buddy
Cheers @Zahid1

[Zahid1 (Zahid)]

Thanks a lot Palaniyappan for such a quick turnaround.
I will check the xaml and will reply back.
Appreciate your help buddy.

[Palaniyappan (Forum Leader)]

sure buddy
kindly let know whether this works or not
Cheers @Zahid1

[Zahid1 (Zahid)]

@Palaniyappan : Thanks a lot Buddy, it’s working perfectly.
You Rock !!!

[Palaniyappan (Forum Leader)]

Fantastic buddy
Cheers @Zahid1

[Zahid1 (Zahid)]

@Palaniyappan,
Need some more help on the same workflow.
Need to update the same input file with the output in Column Period1.

Could you please update the same xaml.

[Palaniyappan (Forum Leader)]

here you go buddy @Zahid1
month (2).zip (17.8 KB)
Cheers

[Zahid1 (Zahid)]

@Palaniyappan,
Thanks a lot. It’s working fine.
Cheers Buddy !!!