topic Casting // Type conversion in Product Forum

Casting // Type conversion

MichalMichalak — Fri, 16 Sep 2016 18:12:00 GMT

Hi All, Is there any way to cast/convert data types in BP Expression Editor?

There are a number of

John__Carter — Fri, 16 Sep 2016 20:11:00 GMT

There are a number of conversion functions like ToNumber for use within an expression. If you want to cast the output of an expression, just use a data item with the type you want in the Store In field. Be aware though that casting is not magic - there are limitations to what can be converted, and an exception will be raised is the cast is illegal.

Thank You @John Carter,

MichalMichalak — Mon, 19 Sep 2016 16:27:00 GMT

Thank You @John Carter, I'll experiment with those 🙂

Hi All,

Vikas — Sun, 12 Nov 2017 19:09:00 GMT

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