I have been trying to find a way to search between dates in Azure Data Explorer but every example or format I find on the internet has led me to more errors. I need to be able to search our Log files between to dates. I found a previous question on here but the solutions do not seem to work for me.

Example of our date time column.

My most recent attempt was
Logs
| where timestamp between ( datetime(2024-06-01) .. datetime(2022-06-02) )
However, the result is between(): all arguments are expected to have the same type ‘long’
Screenshot of error
and then I also tried this example from a previous question on the same subject here
Logs
| where timestamp >=’2020- 05-25′ and ‘Tickets.Resolved Date’ <=’2020-05-26′
Errors