how to display the date set in the user preference date format in BIP report

User has set date format in Oracle fusion "General Preferences: Regional" settings. The requirement is to print the date in excel output as per that setting.

The setting can be d/MM/yy or M-d-yyyy or d.M.yyyy or any other option available in the list of date formats.

I have already tried the below code in rtf and layout but it is not working as per the settings.

<?format-date:CREATIONDATE; 'XDODEFDATE'?>

in my setting I tried with date format "d.M.yyyy" but using the above code it is printing "12-8-2025"

Any pointers to achieve this requirement.