You can't use a template definition in a macro. You have to create a template and call this from within the macro. For example I have 2 templates:
Template 0 is named "Date German" and has the template code [DATE_USER]dd'.'MM'.'yyyy[DATE_USER_END]
Template 1 is named "Date International" and has the template code [DATE_USER]yyyy'-'MM'-'dd[DATE_USER_END]
In a macro which is written for updating dates in HTML files I use the macro commands Template 0 and Template 1.
A second variant is to use the macro command TimeDate to insert date and time as defined in the Windows regional and language settings and reformat it with a regular expression search and replace. I don't like this method because it depends on the date and time format defined in the regional and language settings of Windows. So I don't have control how the inserted date and time looks like. But this variant has the advantage that it does not depend on the currently loaded templates.
Best regards from Austria