Datetime range set to 2010 by default in Query Log Advance Filters Custom Range.

[amasolini]

Versions

• Pi-hole: v6.2.2
• Web: v6.3
• FTL: v6.3.3

Platform

• OS and version: Debian 13 (Raspberry PI OS Lite)
• Platform: Raspberry Pi 3b+

Expected behavior

When using the Advanced Filtering on the Query Log page and clicking on the date/time range field and then selecting the "Custom Range" option, the popup should be showing a default datetime range that is close to the current date.

Actual behavior / bug

When using the Advanced Filtering on the Query Log page and clicking on the date/time range field and then selecting the "Custom Range" option, the popup defaults the dropdowns to "January 2010 to February 2010" on a newly installed version of pihole (installed yesterday).

Steps to reproduce

Steps to reproduce the behavior:

1. Open the admin panel.
2. Click on the Query Log menu section on the left panel.
3. Click on the Date Time range fields and select the "Custom Range"
4. See the default date time range proposed in the popup.

Debug Token

• URL: https://tricorder.pi-hole.net/UDrKQ6GD/

Screenshots

[rdwebdesign]

the popup defaults to "January 2010 to February 2010"

Actually, the default range is set to get anything from 2010 until 2038:

[amasolini]

@rdwebdesign yes, thanks for pointing that out. I forgot to mention this impacts only the dropdown/select elements on the top, which is completely out of sync with what you see at the bottom of the popup. I just made a small edit to the report.

I think both the default range and the selectors should match, and that the range should be from X (arbitrary date in the past) to Today, making it easy to better make a selection of previous months.

[PromoFaux]

I wonder how easy it would be for us to compute the earliest date we have in the database? Latest date can always just be "today"

[rdwebdesign]

Fixed by #3657