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?
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.