Has anyone tried to change the date format in the powerpoint status report extract?

Loren Gifford
Tera Contributor

We have recently installed the plug-in for exporting the status report to PowerPoint. I've made my own version of a template, however I'm stuck as to how to change the format of the dates. I have no need to see the time information. 

Instead of 2022-10-31 08:00:00 AM, I'd like to display 2022-10-31.

Is there a way in the PowerPoint formatter to set up a condition to display only the date?

 

Thank you in advance!

4 REPLIES 4

Jonathan F
Tera Expert

I am also interested in doing the same thing. I can't find any documentation or screens in our instance that gives us any formatting options.

 

I did spot the table sn_ppt_export_ppt_formatter_mapping which appears to give us the ability to apply formatting to fields, which seems like a promising way to apply a specific date format; however, all my attempts to see these formatters applied in my status report exports seem to show it doing nothing. I tried both project_status.project.work_end and project_status.project.status, both of which have entries in that table, and it did not appear to change any of the colors. I tried adding an entry for a status to the project_status.overall_health, and the PowerPoint threw an error instead of giving me any output at all.

Appreciate this is an older post. I have has the same issue but no luck on a solution in SN. I have a macro that runs in powerpoint that sets the date format and a few other fixes around the HTML fields. You need to have both the exported report and a macro enabled powerpoint with the macro in, both open at the same time so that the macro can be run against the report.

 

Happy to share the macro if anyone is interested

vinayugar
Tera Contributor

Could you please share the macro and the steps for applying it?

Thank you in advance!

vinayugar
Tera Contributor

Could you please share the fix for HTML field as well ?

Thank you in advance!