Date format cells in spreadsheet decision tables are converted with double quotation in Business Central

Issue

• Uploading spreadsheet decision table file which has Date format cells are converted with double quotations in Business Central and it leads errors.

• Example:

  • Decision Table converted source in Business Central: reqDateTime >= "“01-Mar-2023"”

  • Error message:

    WARN [org.kie.workbench.common.services.refactoring.backend.server.indexing.drools.AbstractDrlFileIndexer] (Thread-123) Unable to parse DRL for ‘default://master@MySpace/example/src/main/resources/com/myspace/_ex/test.xls’.
    [ERR 102] Line 19:82 mismatched input ‘01’ in rule “Test_Rule_01”
    

• Issue happens on the user defined date format.