Date - Days difference (Bug)

[bernard.lee]

I have 2 dates for the entry.
Highlighted in blue date with time and in grey date only.

(1) Using/Select the type of field -> Date : Days difference
(2) Perform dynamically -> Yes
(3) Exclude last day -> Yes

The result should be 7 day(s) instead of what it has shown on the screenshot.

Is this a bug? If so, could you rectify it? Please advise with thanks.

[support]

This is not bug. It's because you are using date only field type. And it means date format using as 28/01/2019 00:00
So 28 is not including at all in this period. That is why you have 6 days.

[bernard.lee]

This is not bug. It's because you are using date only field type. And it means date format using as 28/01/2019 00:00
So 28 is not including at all in this period. That is why you have 6 days.

Oh I see. Hmm.. is there any formula or using the formula field to calculate it instead?

[support]

You can find some example here http://blog.rukovoditel.net/how-to-use- ... functions/