Hi Uriahs,

Yes, at the moment there could be issues for a scenario like that.

As we pointed out in the Date column Documentation;

• Issues to note:
  • When working with Excel files, it’s the best to set the format of the Date columns as plain text; since the PHPSpreadsheet library that parses Excel files does not parse the Excel date format correctly, which results in an incorrect rendering of the dates (usually they get reset to 01/01/1970).
  • When you’re working with MySQL, please cast timestamps, and datetime columns as dates only to avoid problems.
  • Global search doesn’t support search by date.

At the moment, we can not improve this, but we will do our best to improve it in the future.

I can't promise an ETA on it, though.

2. You are right, at the moment that is the current logic - if we set a Date Picker as the Editor Type or filtering;

by default, it first offers the current date and time.

I will pass your suggestion to our management and developers, they will consider to change it as you requested, but i can't promise if it will be changed and an ETA.

You could create a suggestion for other users to vote, though, so that can affect the decision.

Please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.