08-25-2014 10:49 AM
Does anyone know if there is a problem with the MS Add-in instreaming data from Excel to a STP in Datetime format? I created a flow in EG that imports an Excel file which contains columns of Datetime formats. Those datetimes are used as part of a filtering query and then summarized data is output. The process works just fine within EG. But when I I convert it to a STP and modify the STP under SMC to accept an instream from Excel (the user provides the list of data with datetimes they want processed), apparently what is passed back to the STP is a just a date format. The columns in Excel are clearly formatted and display datetime, but troubleshooting, I put the values to the log and saw that the resulting data was the raw date format and not a datetime.
I have tried a variety of different of importing formats but I am always getting errors. Anyone have experience pulling datetimes from Excel into a STP?