How to use CURRENT_DATE() function in Metabase

Get Help
1

I am trying to set a default value in an SQL query and am following the documentation from

to set a default value of the date.
The portion of my query looks like this

WHERE lsh.effective_date <= [[ {{DATE}} --]] CURRENT_DATE()

I am trying to have the DATE value by default set to the current date. It however doesn't seem to be working as the query is throwing an error whenever I do not select a value for date

2

Hi @sreenath.dressler
Post "Diagnostic Info" from Admin > Troubleshooting.
Try including the error - preferably the full error from Admin > Troubleshooting > Logs.
Does the function CURRENT_DATE() exist on your database? Otherwise replace it with whatever exist on your database. And does your database use -- or # as comment syntax?

3

Thanks figured out my error, I should have been using now()