cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

adding months to a date gives strange behaviour

i ha ve a flow which adds either 1,3 or 12 months to a date field but i am getting inconsitant behaviour does anyone have any ideas?

adding one month gives a month and a dayadding one month gives a month and a dayadding three months is giving 2 days less than 3 monthsadding three months is giving 2 days less than 3 monthsadding 12 months gives exactly 12 monthsadding 12 months gives exactly 12 months

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: adding months to a date gives strange behaviour

Hi @garywalker,

 

I did a test on my side and I also met the situation you mentioned.

The span of adding a month here should be without considering that this month may have 30/31/28/29 days.

I did the another test, and when I alternate between the leap year and the peace year, there will be a day when I add 12 months.

36.PNG

So I suggest changing the Time unit to Day will be more precise.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper I
Helper I

Re: adding months to a date gives strange behaviour

Thanks for looking in to this for me.

Unfortunately, we really need it to be adding months as day/weeks would not meet our acceptance criteria. Where would be the best place to raise this as a bug?

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (9,568)