Has anyone tried to change the date format in the powerpoint status report extract?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2023 12:03 PM
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-27-2023 12:53 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2024 03:30 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2024 02:45 AM
Could you please share the macro and the steps for applying it?
Thank you in advance!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2024 02:49 AM
Could you please share the fix for HTML field as well ?
Thank you in advance!