Date fields throwing error

[mohiit_jain3]

My dimension group of date is apparently throwing errors when included in the dashboard. Can someone help me resolve this issue?

the field looks like (using bigquery db):

inserted_date{

type: time

timeframe: [

raw,

time,

date,

week,

month,

quarter,

year

]

sql: ${TABLE}.inserted_date;;

error this throws when included in the dashboard or filter:

when included in the filter--

The Google BigQuery Standard SQL database encountered an error while running this query.
Query execution failed: - No matching signature for operator >= for argument types: DATETIME, TIMESTAMP. Supported signature: ANY >= ANY at [11:7]

when included as a field--

The Google BigQuery Standard SQL database encountered an error while running this query.
Query execution failed: - No matching signature for function FORMAT_TIMESTAMP for argument types: STRING, DATETIME, STRING. Supported signatures: FORMAT_TIMESTAMP(STRING, TIMESTAMP, [STRING]); FORMAT_TIMESTAMP(STRING, DATETIME) at [2:6]

Also, the raw and time field doesn’t show up in the dashboard even after everything is merged.