AddWeeks to date column but February came back with 31 days instead of 28 days

[Anonymous]

Hi,

I want to add six weeks to my planned date column but for one cell February came back as 31 days, when we know its only 28 days this year.

I used : Date.AddWeeks([Planned Sprint],6)

Planned date: 19/11/2019 - Caculated date: 31/02/2020

How do I correct 31/02/2020 to 28/02/2020?

Thanks

Liz

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

I can't reproduce your problem.

As tested with this funtion, it shows expected value.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

Sorry I look at the wrong data set. I've sorted it out now.

Thanks for your time and assisstance.

Liz 

[edhans · Accepted solution]

It isn't possible to have a 31/2/2020 date. February never has 30 or more days. But Feb 29, 2020 is legit. You can see at the top I'm using the same Date.AddWeeks() function.

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

I can't reproduce your problem.

As tested with this funtion, it shows expected value.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[artemus]

I'm not sure I follow.

First there are 29 days in Febuary this year, not 28.

Second, November 11th 2019 + 6 week = December 31st 2019, or 31/12/2019

If you are sure you are seeing a Febuary 31st date. Is this possibly a string instead of a date? Power Bi will reject any attempt to create that date.