Microsoft Flow – Next Month is okay, but don’t go any further!

View Comments

• This has been driving me crazy as well, and I believe it should continue to be a bug as the desired normal functionality is not working as expected.

  That being said, I do believe I have found the reason behind the inconsistency and possible methods to fix this. This method is expected to take the input of interval and add that number of months to the current date, however through initial testing, the actual functionality takes the interval input and adds the number of days in the month corresponding to that number and adds it to the date. So if the interval is 1 it adds 31 because 1=January, 2 would be 28 because 2=February, 3 would be 31 because 3=March and so on and so on.

  Here is the output data from tests run with the starting date of 05/10/2018:

  Interval Date Output Difference in Days
  0 05/10/2018 0
  1 06/10/2018 31
  2 07/08/2018 28
  3 08/08/2018 31
  4 09/07/2018 30
  5 10/08/2018 31
  6 11/07/2018 30
  7 12/08/2018 31
  8 01/08/2019 31
  9 02/07/2019 30
  10 03/10/2019 31
  11 04/09/2019 30
  12 05/10/2019 31

• I hope that this one will be fixed soon.