Using a Date field in dimension group causes format_timestamp error

[PowdyPowPow]

Hi,
when using master_stats.Date dimension group we get the following error:

At least in our tables the Date field is actually a date field not a timestamp. This error can be fixed by converting the date field to timestamp in the master_stats view:

dimension_group: date { type: time timeframes: [raw, date, week, month, quarter, year] convert_tz: no sql: TIMESTAMP(${TABLE}.Date) ;; }

Thanks,

[PowdyPowPow]

The same issue with campaign End date.

dimension_group: end { type: time timeframes: [ raw, date, week, month, quarter, year ] convert_tz: no sql: TIMESTAMP(${TABLE}.EndDate) ;; }

The campaign start date was already converted into timestamp.