error date filter

Hello, if I put a filter on the date field I have this error

invalidQuery: No matching signature for operator >= for argument types: TIMESTAMP, DATE. Supported signature: ANY >= ANY at [34:11]

Make sure that in the definition of your dimension_group you have added type:time

@Dawid if that’s what i did

Change datatype to timestamp or datetime

1 Like

@Dawid Thanks

if i have 2 views with each of the views has a date field is it possible on looker to filter from a single date filter from one view the measurements from the other view

In this case you could probably leverage the usage of Templated Filters. You can create a filter of type date_time and then feed its values as logical statements to the sql parameter of your timestamp dimensions. Here is a link that could help:

https://help.looker.com/hc/en-us/articles/360001285847-Timeframe-vs-Timeframe-Analysis-Using-Templated-Filters