Milestone Timestamps do not match application Generate Report to Excel Workbook

Milestone Timestamps do not match application Generate Report to Excel Workbook

matthew_w5
Not applicable
163 Views
4 Replies
Message 1 of 5

Milestone Timestamps do not match application Generate Report to Excel Workbook

matthew_w5
Not applicable

[ FlexSim 24.2.2 ]

I'm running a fairly simple model in Healthcare 24.2.2. I have 2 workflows that use unique Milestones for each workflow. When I run the experimenter and view the results on the Statistics Table tab, the milestone timestamps all appear to be populated with the correct values. However when I select the 'Generate Report' option and create an Excel Workbook, the timestamps for one of the workflows are no longer accurate and do not match the Person Milestones table in the application. Interestingly, if I export to CSV files, the values do appear to be populated appropriately, so it's only the export to the Excel workbook that is having issues.

I also only see this with one workflow, not both. Perhaps related, the non-populated milestone timestamps for the problematic workflow export as 'NULL', while the workflow that does extract appropriately, the non-populated timestamps export as '1/0/1900 12:00:00 AM' to Excel, while in the CSV extract, the non-populated values all export as '1/1/1601 12:00:00 AM'.

I don't want to publicly upload a copy of this .fsm due to potential organization identification, but I have added a couple screenshots of the export and the table within the workflow application.

Excel Export Person Milestones.png

0 Likes
Accepted solutions (1)
164 Views
4 Replies
Replies (4)
Message 2 of 5

Jeanette_Fullmer
Community Manager
Community Manager

Hi @Matthew W5,

Thank you for contributing to our community! We couldn't identify a maintained license or subscription linked to your account.

You may need to update your profile information to identify yourself as a license owner or their associate. Check out our article for how to ensure you receive timely support. If you update your profile comment back to let us know - we'll adjust the priority of your post accordingly.

If your current license is expired, please contact your local distributor to renew.

0 Likes
Message 3 of 5

matthew_w5
Not applicable
Hi @Jeanette F , I didn't realize my license information was no longer attached. I have had it re-added. Do I need to repost this question?
0 Likes
Message 4 of 5

Jeanette_Fullmer
Community Manager
Community Manager
No, I will update your priority in our tracker
0 Likes
Message 5 of 5

Jeanette_Fullmer
Community Manager
Community Manager
Accepted solution

Hello @Matthew W5,

This has been sent to the development team for further investigation.

0 Likes