1

I am using query function to copy all data from sheet1!A2:B10 to Sheet2 if B column is equal to specific data/time. Lets say A1 = 5 April 2021 A2:A10 names B2:B10 has Timestamp And I used this formula

Query(sheet1!A2:B10," select * where B=A1+31/24",0) which means query all data if B = 6 April 2021 07:00

But query doesn't accept such format. Any thoughts? one Idea to create a column C where I put the date/time static (6 April 2021 07:00) and use query(sheet1!A2:C10,"select * where B=C",0) but seems I have to convert column C to text as well..

1