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.

Hallo, I am new on programming Object Script.

My problem: How can I use a String variable in embedded SQL?

The below example does not work by using: namevar with ' ' 

set namevar = 'Ali'

&sql(DECLARE C2 CURSOR FOR SELECT name INTO :name FROM person where name = 'namevar')

Only below will work: person where name = 'Ali' 

Thanks in advance