Can't Filter Table with DateTimePicker

Queries and Resources
5

I've got a similar question/issue like this one that

  1. I've tried this:
    select e."Date", CONVERT(varchar(10),e."Date") as [Short_Date] from entries e
    --syntax error at or near ","

  2. And this:
    select e."Date" from entries e WHERE e."Date".format('YYYY-MM-DD') = {{ moment(datePicker1.value).format('YYYY-MM-DD') }}
    --cross-database references are not implemented: e.Date.format. Position 38