I have a custom question where I am trying to implement the filter that looks like below in sql:
date(coalesce(due_timestamp, completion_timestamp)) < current_date
Is there a equivalent of current_date in custom expression. This is what I have tried but it errors out.
= current_date < coalesce([due_timestamp], [completion_timestamp])
I want to leverage the sorting and filtering capabilities of tabular representation of data so I can’t write a custom sql question for this.