Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Duration.days returning false values (Power Query)

Hello Everyone,    I am using duration.days to calculate the duration between two dates. But the result is sometimes right and sometimes wrong.  For example between 28/04/2020 and 04/05/2020 it sh...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Should i add 1 to the result?

Mahesh0016's avatar
Mahesh0016
Super User
3 years ago

No Anonymous  ,because if you add 1 so  in this scenario05/05/2020 and 06/05/2020 it returns the correct result which is 1 answer will be wrong.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Then should i just leave it like this?