Answered

Add number of month to a date

(0) Share

Report

Posted on by Assad

I have problem with Add to time when adding for example 6 month. Add to time adds always 30 days resulting in the wrong date in the future. se below

using below on 15-04-2019 witll result in 13-10-2019 and not 15-10-2019

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Assad

It appears as though the issue is with the NextDate and not with the Add to Time action. Can you post a screen shot from a run that shows the Add to time action. That will allow you to see the NextDate input.

Was this reply helpful? Yes No
Assad 13 on at

Like (0)

Report
Copy link

Link copied!

Hi @Scott

You have the same issue in your example. you startdate is 22 and the end date is 20
Her is another exampel from my flow running adding just one month ending with wrong date 13-04 ends as 14-05
because it adds 31 days when april to may is only 30 days

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Assad ,

Thanks for feedback.

The issue could be reproduced by me.

I will help report it and back to you later.

Best regards,

Mabel

Was this reply helpful? Yes No
Assad 13 on at

Like (0)

Report
Copy link

Link copied!

Thanks. if not a bug fix maybe a workarround will be nice. I have customer waiting to go online

Was this reply helpful? Yes No
Assad 13 on at

Like (0)

Report
Copy link

Link copied!

I created a very ugly logik that do the job. the next step is to beatify the logik. any other ideas is welcome
1- I need the to find if february is 28 or 29 days
if(or(equals(mod(int(formatdatetime(variables('Date'),'yyyy')),400),0),
and(equals(mod(float(int(formatdatetime(variables('Date'),'yyyy'))),4),0),
not(equals(mod(int(formatdatetime(variables('Date'),'yyyy')),100),0)))),29,28)

2- Adding 3 month as an example
The idea her is to do until 3 times
find the correct number of days and updating "Date" until i have my
final result "Date"
if(equals(formatdatetime(variables('Date'),'MM'),'01'),'31',
if(equals(formatdatetime(variables('Date'),'MM'),'02'),variables('Leap'),
if(equals(formatdatetime(variables('Date'),'MM'),'03'),'31',
if(equals(formatdatetime(variables('Date'),'MM'),'04'),'30',
if(equals(formatdatetime(variables('Date'),'MM'),'05'),'31',
if(equals(formatdatetime(variables('Date'),'MM'),'06'),'30',
if(equals(formatdatetime(variables('Date'),'MM'),'07'),'31',
if(equals(formatdatetime(variables('Date'),'MM'),'08'),'31',
if(equals(formatdatetime(variables('Date'),'MM'),'09'),'30',
if(equals(formatdatetime(variables('Date'),'MM'),'10'),'31',
if(equals(formatdatetime(variables('Date'),'MM'),'11'),'30',
if(equals(formatdatetime(variables('Date'),'MM'),'12'),'31','31'))))))))))))

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Assad ,

The issue has been reported.

PGs are working on a fix on this issue.

However, I am afraid that there is no easy workaround for this.

Best regards,

Mabel

Was this reply helpful? Yes No
Verified answer

Assad 13 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yamao-msft
I tried to do a work arround my self. I am not sure if it could be done in another way but her is the work arround

Step 1 - Insure Leap year for february is it 28 or 29 - it is tested and works fine

if(or(equals(mod(
int(formatdatetime(variables('Date'),'yyyy')),400),0),
and(equals(mod(float(int(formatdatetime(variables('Date'),'yyyy'))),4),0),
not(equals(mod(int(formatdatetime(variables('Date'),'yyyy')),100),0)))),29,28)

Step 2 - adding 3 month as an example
I used a do until count 3 times. That adds the correct number of days from the month
reached in the continiously updated variable "Date".

if(equals(formatdatetime(variables('Date'),'MM'),'01'),'31',
if(equals(formatdatetime(variables('Date'),'MM'),'02'),variables('Leap'),
if(equals(formatdatetime(variables('Date'),'MM'),'03'),'31',
if(equals(formatdatetime(variables('Date'),'MM'),'04'),'30',
if(equals(formatdatetime(variables('Date'),'MM'),'05'),'31',
if(equals(formatdatetime(variables('Date'),'MM'),'06'),'30',
if(equals(formatdatetime(variables('Date'),'MM'),'07'),'31',
if(equals(formatdatetime(variables('Date'),'MM'),'08'),'31',
if(equals(formatdatetime(variables('Date'),'MM'),'09'),'30',
if(equals(formatdatetime(variables('Date'),'MM'),'10'),'31',
if(equals(formatdatetime(variables('Date'),'MM'),'11'),'30',
if(equals(formatdatetime(variables('Date'),'MM'),'12'),'31','31'))))))))))))

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Assad ,

Thanks for sharing.

It would be helpful for other customers who have the same issue. I really appreciate the workaround you’ve provided.

Hope the issue could be fixed soon.

Best regards,

Mabel

Was this reply helpful? Yes No
robertoz 7 on at

Like (0)

Report
Copy link

Link copied!

Hi All,
it seems to be fixed already:

Was this reply helpful? Yes No