I have a long datasheet and i would like to filter it by moving only data from january etc. into another sheet in the workbook.

I would also like a sheet to show data from today.

This is the formula I was trying to use but it is not working. Im not sure what I am doing wrong.

=query(IMPORTRANGE("1qjOk6EGslZUsjEkv3vxafFmKZQyeDFBsDCYmzWuoW6U","Reservation!a:ah")," where col10=today() ",1)

Can anyone help?