Date format is not same in the application and in the downloaded report

Date format is not same in the application and in the downloaded report
in the application im getting MM-DD-YYYY but on download the custom report im getting YYYY-MM-DD but i need to have MM-DD-YYYY could any help on this

go to Settings > System Settings and set the Date Format to MM-DD-YYYY. If using a custom script or report builder, ensure the date fields are formatted correctly within the report before export.

in the application it looks fine after export to excel file then the format is changed to YYYY-MM-DD even after making the changes you suggested

Ensure that your system and browser local are aligned with the date format you want.

Basically Database format is YYYY-MM-DD

So, on export the data fetch from database that’s why in excel or in pdf or in print the date comes in YYYY-MM-DD format.

After the download the excel file. Open it and change the date format manually…

And

In the case of print and pdf you can use doc.get_formatted("date_fieldname")

thanks for the explanation