Change data format for Scheduled Email of Report

[Gaetano De Mitr]

Hi everyone,

I'm using Scheduled Email of Report, but

How can change date format of data fields from yyyy-MM-dd to dd/MM/yyyy?

Thanks,

Gaetano

[Ankur Bawiskar]

Hi De Mitri,

I think you can achieve using this.

1) create a user which has role to execute report and execute schedule report i.e. report_admin role

2) for this user in his profile set date format to the one you want dd/MM/yyyy

3) there is a Run as field on scheduled report, set it with this user

Allow the report to run and check what are the values of date in the report

This solution has worked for me for csv, pdf file and it should work for xls file as well.

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Bharath K B2]

@Ankur Bawiskar This is working when I export the data in PDF format. But when I export in excel format the date format is remaining YYYY-MM-DD. Is there a way I can get the required format in excel as well?

[Ankur Bawiskar]

Not very sure how the behavior is for excel.

Seems it might be taking the system format YYYY-MM-DD

[Ankur Bawiskar · Accepted solution]

Hi De Mitri,

Any update on this?
Can you mark my answer as correct, helpful if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.

Regards
Ankur