Casting // Type conversion

[MichalMichalak]

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

[John__Carter]

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.

[MichalMichalak]

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

[Vikas]

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