Decision Management (ODM,ADS)

 View Only
Expand all | Collapse all

Issues with Excel Exports using Custom Scenario Provider

  • 1.  Issues with Excel Exports using Custom Scenario Provider

    Posted Tue November 29, 2016 05:40 PM

    I am using the Custom Scenario Provider and exporting files to excel, but it’s not displaying the date correctly. I want it to display 01/01/0001 but it’s displaying as -1. The rules were executing correctly, but excel couldn’t’ display it. Any idea why this is happening?



  • 2.  RE: Issues with Excel Exports using Custom Scenario Provider

    Posted Wed December 07, 2016 09:32 AM

    Hey Mary,

    This is a known limitation of Excel: Year 1900 problem Microsoft Excel cannot display dates before the year 1900, although this is not due to a two-digit integer being used to represent the year. Excel uses a floating point number to store dates and times. The number 1.0 represents January 1, 1900.



  • 3.  RE: Issues with Excel Exports using Custom Scenario Provider

    Posted Wed December 07, 2016 09:40 AM

    hmmmmm, that's weird. Thanks Daniel.