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...
because of 28/04/2020 is excluding it is not including.
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?