Linking back to original file from dateview query

[prince]

What I’m trying to do

First of all my daily notes are created as DD MMMM YYYY,DDDD. They have the property called “Created” which is a date.

table without id
	file.link as links,
	dateformat(created,"dd") as Date,
	choice(x,"✅","❌") AS 🪥
from "Daily Notes/2024/February"
sort Days ASC

This query returns the file link the dd part of the created property and a checklist item x.

What I want it to do is return the dd part of the created property which links back to the daily note and a checklist item x.

So, it would show some thing like

where the 04 part the dd part would be a link back to the file it came from in this case the file named 04 February 2024, Sunday.

Things I have tried

I tried to do this by using the following query:

table without id
	[dateformat(created,"dd")](file.link) as Date,
	choice(Brush-Twice,"✅","❌") AS 🪥
from "Daily Notes/2024/February"
sort file.name ASC 

But this just ends up in some error

[prince]

Solved it.

table without id
	link(file.link,dateformat(created,"dd")) as Date,
	choice(x,"✅","❌") AS 🪥
from "Daily Notes/2024/February"
sort Days ASC

Hope this will help someone out in the future.