Change data type after importing excel

[Vikas]

Changing Data type Hi All, I imported excel to local undefined collection. Excel has fields Date and Quantity. when i imported them the datatype is text for every column. How to change datatype back to date ,quantity for whole column where my excel has 1000 rows. Thank you in advance

[John__Carter]

Create a second collection with the data types you want, then use a calculation with [Coll1] as the expression and Coll2 as the Store In. Note however that this assumes a direct cast is possible BUT in BP there is no concept of null, so datetime and number columns in the Excel file that contain blanks will not cast in this way. This is why text has been used for all columns in the collection.

[Vikas]

Thank you