May 16 2022 01:17 AM - edited May 16 2022 01:21 AM
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.
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?
May 16 2022 01:41 AM - edited May 16 2022 01:44 AM
@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.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)