EBS : Excel Template

Using E-Business Suite 12.2.10.

Excel Template

I am converting some of the standard EBS financial text base output reports to Excel. Using BIP I am wanting to show the report date in the output. in other words the date the report is run. When the report output(excel) is saved and opened sometime later the report date will not change

I have tried the following in the XDO_METADATA worksheet

<?xdofx:sysdate()?>

<xsl:value-of select="current-date()" />

With out any success.

Do you know how to get the current_date function to work using a Excel template with EBS ?

Thanks