Advanced date filtering - prior day appears in results

[michael_wall-16]

I’m using the advanced date filter to select absolute number of days from a specific date. In the documentation, it says the following: 

2018/05/10 for 3 days

from 2018/05/10 00:00:00 through 2018/05/12 23:59:59

However in my results, the prior day is appearing: 

Anyone aware of a bug or if there’s a particular reason for this?

[michael_wall-16]

I figured it out, the datatype was timestamp_tz which must have been causing some issues when converted to dates by Looker. I cast my timestamp to ntz which resolved the issue.