I have a what seems to be a simple but odd finding. When I use:

WHERE DateTime >= '2024-04-01' AND DateTime <= '2024-04-30'

This above only gives me up to 04/29, but not 04/30

WHERE DateTime >= '2024-04-01' AND DateTime < '2024-04-30'

This also only gives me up to 04/29, but not 04/30

Which is weird, why is <= treated the same way as <?

Thank you!