Formula for filtering a date range

[johneodell]

I have a simple formula for filtering data to pick up only a specific date range. However when testing it I discovered I am only getting the day before the last date in the range. 

Here is the formula:

[endingDateTime] >= '2019-12-01'
AND
[endingDateTime] <= '2019-12-31'

I'm getting results from 12/1 to only 12/30 with the 12/31 results being left out (and yes, there is data for the 12/31 date)

I have a feeling that I am missing something very simple and obvious...

[JTB76]

Awesome!  Thanks for that.  Worked a treat!

[mahmood809]

Hi @DiganP I want to change this filter to alteryx analytic app (Dynamically i can select date), Is it possible?