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

1

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

2

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.

3

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

4

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

5

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")

6

thanks for the explanation