Filtering dates 'in the past [X]' - Looker inserts empty string into CURRENT_DATE('')

[joe_c1]

Hey all,

I’m trying to figure out this weird error I’m getting. When I filter my dates with ‘is in the past 5 months’, I get the error `Query execution failed: - Invalid empty time zone`, but when I use a date range for the filter, there is no issue.

I looked into the SQL code behind the scenes, and it seems like Looker is using CURRENT_DATE(‘’) with an empty string for the ‘is in the past ’ filter. Has anyone experienced this? Any suggestions to still use the ‘is in the past ’ filter without having this issue.

Thanks!

Joe