I managed to create a workaround for this using the QuickAdd plugin, Obsidian Advanced URI plug-in, and a script file;
Using the workaround from https://forum.obsidian.md/t/quickadd-plugin/20032/13, you can assign a shortcut to open a specific workspace from the command palette.
Then you can use use the QuickAdd macro feature to chain opening specific workspace command that is followed by the command to open the current day in the active workspace. And then assign a keyboard shortcut to that macro.