Transclude variable today date note

“Daily Notes” is one of the core plugs.
You turn it on and tell it where to find the template.

The name of the note is the date and then in the template I have:

{{title}} {{date:dddd}}

Because the date is the name/title of the file the {{title}} variable displays the date in YYYY-MM-DD format. The second variable, {{date:dddd}} displays the day of the week.

If you go into “core plug-ins” then “daily notes” and then click on the tiny configuration gear, the last option is:

Open daily note on startup
Open your daily note automatically whenever you open this vault.

Does that option do what you want?

Daily note creates the note for the date using the template you specify and you can choose to have the daily note automatically displayed when you open the vault.

There is also this note from osgav:

The Daily Notes plugin does not use the default {{date}} token from the Templates plugin. You need to specify the format. This will work → {{date:YY-MM-DD}}
{{date}} variable in Daily Notes plugin - #2 by osgav

This blog post may also be helpful.