Error in insights dashboard custom filter - Returns "`year-month-day`" date or `null` if the date would be invalid

[Rohit_More]

Hi,

I’m writing a custom filter for a dashboard in Insights, but while doing comparison of dates I’m gettnng below error:

Expression incomplete.

date(year, month, day)
Returns “year-month-day” date or null if the date would be invalid

Below is the expression:
date(extract_years(${queues.creation_date}),extract_months(${queues.creation_date}),extract_days(${queues.creation_date})=date(extract_years(now()),extract_months(now()),extract_days(now()))

[Rohit_More]

Resolved, a paranthesis was missing

date(extract_years(${queues.creation_date}),extract_months(${queues.creation_date}),extract_days(${queues.creation_date}))=date(extract_years(now()),extract_months(now()),extract_days(now()))
AND

${queues.queue_name}=“Client Security Hash Code Generation”