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.