jsemeano 0 Posted September 10, 2012 Share Posted September 10, 2012 Hello, I've been using the excel import button to update my tables before running the model. Turns out that, for no obvious reason, sometimes SIMIO feels like changing the days with the months. Is there any easy way to overcome this problem? This is quite an urgent matter. In the image you can see a right (green) and a wrong (red) case during the same import. At the right there's the Excel table and at the left there's the SIMIO one. http://s9.postimage.org/w60ypi573/day_and_month_switch.png Best regards, everybody, João Link to post Share on other sites
jsemeano 0 Posted September 10, 2012 Author Share Posted September 10, 2012 PS: any time the day is smaller or equal to 12 SIMIO assumes it's a month Link to post Share on other sites
tulach 2 Posted September 10, 2012 Share Posted September 10, 2012 Looks like a nice bug. Best thing to do is to report it to support@simio.com, they will help you. In mean time I would recommend changing your system settings for date in windows to English US, I sometimes have difficulty with regional settings (Czech Republic) so I often use American settings and problems disappear. Link to post Share on other sites
jsemeano 0 Posted September 10, 2012 Author Share Posted September 10, 2012 Thanks for the prompt response, tulach, I have done some scavenger hunts through hell trying to change the regional settings. Seldom have I been successful. I'll give it another try, though. Thanks again, and long live Nedved, João Link to post Share on other sites
tulach 2 Posted September 10, 2012 Share Posted September 10, 2012 Dont forget to write to support. Link to post Share on other sites
Recommended Posts