Hey Community,

It's time for the new batch of #KeyQuestions from the previous month.

Here are the Key Questions of November chosen by InterSystems Experts within all Communities:

📌 Non ascii characters got considered as a question mark inside regex engine. Is this a bug ? by @Norman W. Freeman (EN)

📌 Regarding best practices for integration between different datasets and namespaces by @Matheus Augusto (EN)

These questions will be highlighted with the #Key Question tag, and their authors will get the Key Question badge on Global Masters.

If you find the key question(s) from other communities interesting, just drop us a line in the comments, and we will translate the question(s) and the accepted answer(s).

Congrats, and thank you all for your interesting questions. Keep them coming!

See you next month😉

Hello, 

I am using Object Script with Phyton to import an Excel File. 

Please see the below code. Its works fine for all text and numeric Columns. But by importing a DATE formated column in Excel (birthdate) , Iam facing the below issue as result:

My question: How can i import date formated Excel Data in Object Script?

Thanks a lot in advance

Maikel

       Set tSC = $$$OK
        Set tData = ##class(%SYS.Python).Import("openpyxl")         Try 
        {
            /// Pfad zur Excel-Datei
            Set filePath = pInput.Filename
            $$$TRACE(filePath)
           
            Set pyWorkbook = tData."load_workbook"(pInput.Filename)
            Set pySheet = pyWorkbook.active
            Set maxRow = pySheet."max_row"
            ........

            Set MolDatum = pySheet.cell(i,y) m