Forum Discussion
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...
I don't think so, because it gives correct results for other dates, like 04/05/2020 and 07/05/2020. it returns 3
it gives correct results for other dates, like 04/05/2020 and 07/05/2020. it returns 3 , YES because 04/05/2020 is excluding and 07/05/2020 is including i.e (05/05/2020,06/05/2020,07/05/2020) , you should count other dates day.
How can i correct this then ?
Should i add 1 to the result?
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.