QUERY help

[Ronderbecke]

I have a formula that I cannot seem to get to work. I am sure it is something super simple and im overlooking something but I would greatly appreciate any help on this.

QUERY(Data!A2:F,"where D=>'"&E1&"' and D=<'"&F1&"'")

I am simply wanting to make sure the date in D is between a start of E1 and an end of F1 (both E1 and F1 have dates)

Thanks

 

[Ronderbecke]

SOLVED! Sorry, I knew it was something small. Forgot to convert to text. In case anyone has problems like this, here was the solution:

QUERY(Data!A2:F,"where D >= '"&TEXT(E1,"YYYY-MM-DD")&"' and D <= '"&TEXT(F1,"YYYY-MM-DD")&"'",1)

 

[Ronderbecke]

My Apologies and perhaps someone can help with the error occurring in the new formula. I don't know why I have so much trouble with Date and Time function on this. The formula is not pulling any of the correct information. When the dates are 2018-11-26 on E1 and 2018-12-02 on F1, its giving back one result that is appointment date 2018-12-05?

The listed is formatted: 2018-12-05T18:00:00-05:00 I can't imagine the formatting has anything to do with it thought as the formula converts it to text?