You can use API Query to get answer back soon easily
1st red = base id 2nd red = api key
{name} = colum name which contain the date.
I have searched the date b/n 2022 jan to 2023 jan records
If the above image is not clear, make use of this