When creating a filter list using DATETIME type data, take into consideration the time zone of the DATETIME type data stored in the original list.
When storing DATETIME type data in the original list, store it in UTC format. Even if you store it in JST format, it will be treated as UTC format data, so you may not be able to narrow down the results correctly using the filter list.
For example, if 2024-04-17 19:00:00 is stored in the original list in JST format, when you extract data corresponding to 2024-04-17 in the filter list, you will not be able to obtain data for 2024-04-17 19:00:00.
This is because the data is interpreted as 2024-04-18 04:00:00 during extraction, and is not treated as 2024-04-17. To perform accurate filtering, store the original list in UTC format.
You can check details inhere.
