Date Subtraction

Brass Contributor

Hello.

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.

Freenit_0-1652689048735.png

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:

DateDiff2.png

 

the official Microsoft documentation which states this is here.

 

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