Date range filter not working if min and max date field have same date value in view

Created on 15 March 2022, almost 3 years ago

Updated 21 February 2024, 10 months ago

I have created a view called "Articles" with date range filter. I have installed Date Popup module for date selection. But when I select same date in Min and Max field and perform filter it is not working. Please refer screenshots for more details.

Steps to reproduce:

Create view with date range filter
Perform filter with same date in min and max field
It won't show any data even data is present.

I have checked view's query and found that it is happening because of timestamp comparison. Same date will have identical timestamp and because of this no record is showing.

🐛 Bug report

Status

Closed: duplicate

Version

1.0

Component

Code

Created by

🇮🇳India chandreshgiri gauswami

Live updates comments and jobs are added and updated live.

Incomplete comments

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Comment about 1 year ago →
🇳🇱Netherlands gaele
https://www.drupal.org/project/date_popup/issues/3311959 🐛 Less than or equals operator doesn't work with fields that have a time component Needs review
Comment 10 months ago →
🇬🇷Greece pappis Greece
#3 🐛 Date range filter not working if min and max date field have same date value in view Closed: duplicate helped me.
In my case I used "node_field_data.created BETWEEN"
But is is not a universal solution.
This is a serious bug. I wonder how other people overcome it.

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024