Showing results for 
Search instead for 
Did you mean: 
Community Champion
Community Champion

Bug report: DateValue("15/15/2016") gives 15 March 2017

This is clearly not proper behaviour as it would allow erronous entries by the user to go undetected.

Many thanks for any feedback.


Not applicable

Hello @Meneghino,


It looked so weird that tried to figure out if it could have any explanation, and after triing several creative formulas, tried that one to add days:




 I am assuming that the day value, month value, and year value may be some sort of indivual int fields, so you can do calculations directly into them, like adding days on the example.

It also works weird stuff like DateValue("15/10/2016")+Day , but when you start adding parameters it completely screws up with the result, outputting nosense, despite accepting almost anything as parameter.

Probably we are not introducing the correct syntax, but it is accepting it, so as you said they should add some sort of control over it, so it is easier to understand how do you operate with dates.


Best regards.

Thanks, I opened a bug for this errant behavior.

Has this been fixed? Is there a way to set the date to display DD/MM/YYYY format on a datacard form?

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (3,102)