Handling datetime conversions using spotfire.set_spotfire_types() to set datetime64[ns] types in pandas to 'Date' types in spotfire is not supported. You get the error:
spotfire.sbdf.SBDFError: cannot convert Spotfire DateTime type to Spotfire Date type; incompatible types
Since converting to a date type in pandas is really just converting to an object, it's not memory efficient and often doesn't work when you have to use the .dt.date function on a pandas series. We need support for converting native datetime64[ns] data types in pandas to spotfire Date type so this can be done in python.
Handling datetime conversions using spotfire.set_spotfire_types() to set datetime64[ns] types in pandas to 'Date' types in spotfire is not supported. You get the error:
spotfire.sbdf.SBDFError: cannot convert Spotfire DateTime type to Spotfire Date type; incompatible types
Since converting to a date type in pandas is really just converting to an object, it's not memory efficient and often doesn't work when you have to use the .dt.date function on a pandas series. We need support for converting native datetime64[ns] data types in pandas to spotfire Date type so this can be done in python.