Parsing Failed - when executing simple dataview query

[cvasanthk]

Hi,
I'm new to Obsidian and Dataview.
During 'daily note template' creation I tried to add a simple dataview query as below:

Files created this day

list
where file.cday=date(<% tp.file.title %>)
sort file.ctime desc

### Files modified this day
``` dataview
list
where file.mday = date(<% tp.file.title %>)
sort file.ctime desc

WHile executing, I get the below parsing error:
Dataview: Error:
-- PARSING FAILED --------------------------------------------------

1 | list

2 | where file.cday=date(<% tp.file.title %>)
| ^
3 | sort file.ctime desc
4 |

Expected one of the following:

'(', ')', 'null', boolean, date, duration, file link, list ('[1, 2, 3]'), negated field, number, object ('{ a: 1, b: 2 }'), string, variable

Any guidance to make this work will help.

[Tatiana-Chernyshova]

Hi.
I myself have been looking for a solution to this problem for a very long time.
Here is the solution (in case anyone needs it):

```dataview
LIST
WHERE file.cday=date("<% tp.file.title %>")
```

Or like this (but it seems to return the same value here too, so both options should work):

```dataview
LIST
WHERE file.cday = date("<% tp.file.title,'DD-MM-YYYY' %>")
```

I haven't yet figured out if it is necessary to specify ,'DD-MM-YYYY'
Or is it enough to put <% tp.file.title %> in “”