Date Subtraction

Brass Contributor


I am trying to subtract two days in PowerApps:



DateDiff( Now(), DateValue("1/1/2014") )



Logically the result should be a positive value, but I get the negative one.
According to the specification, it also should be positive.


Could someone explain why the result is negative?

I have made some experiments and If I change the position of members then I got a positive result.
So, why the PowerApps is working not according to specification?


1 Reply

@Freenit in a DateDiff function the first date should always be the start date and the second date the end date. You can see it working on one of my apps below:



the official Microsoft documentation which states this is here.


Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)