managed to get it work, to be honest I’m not sure what I’ve done! happy to share the code if you’d like it

I managed to get some joy with using type: date_raw. In general dates in Looker seem a hassle to deal with!

I’m seeing a similar issue where it tries to convert to a timestamp using london zone and takes off an hour in months during BST then it converts to date meaning the calculations are a day out ** update ** fixed it using convert_tz: no

Thanks for the quick response. Can you give an example of the casting workaround please? Thanks John

I’m struggling to implement this when I use my date dimension as dimension_group: fulldate { type: time timeframes: [year, month, week_of_year, day_of_week, week, date, raw] sql:${TABLE}.datepartition ;; } I get a No matching signature for function F...