search dateTime : between

[item]

Dear,

when we make a search on dateTime field with 'between'

start : 01/02/2019
end : 28/02.2019

result go from 01/02/2019 to 27/02.2019

then he do :
>= start AND < end

it's normal behaviour or ..

do you think is good behaviour ?

>= start AND <= end. is not better ?

Regards

EspoCRM : 5.6.0
php : 7.1.2

On SelectManagers/Base line 1071

$dt->modify('-1 second');   =>  $dt->modify('+1 day -1 second'); 

[yuri]

It's it normal? I was persuaded that it's how it should be working.

[item]

Thanks Yuri,
it's "normal" .. then it's perfect
I just make this and it's so too :

SELECT *
FROM `contact`
WHERE (date_time BETWEEN '2019-02-01' AND '2019-03-01') 

And result is like "EspoCRM".. then it's me the "not normal"..
Maybe too because in Belgium, when we talk between 2 dates, it's always >= and <=

Regards

[yuri]

Recently there was one not careful fix. I will it fix so that it will be working like

date_time BETWEEN '2019-02-01 00:00:00' AND '2019-03-01 23:59:59'

Thanks for reporting.