Error message: Expression evaluation error at function 'tointeger' param

shaoyongw over 7 years ago

Error message: Expression evaluation error at function 'tointeger' parameter 1: Cannot sub incompatible operands of type List of Variant and type Date with Timezone.

The expression is like: tointeger(data_array - today())

Any ideas how to deal with it?

Discussion posts and replies are publicly visible

Parents

0 sikhivahans over 7 years ago

@shaoyongw As explained above by other practitioners, you may need to depend on type casting where you may use Conversion Function todate() or you may also use typeof() in combination with cast() on the data_array.

Just in case, if the data_array is an output of the queryEntity, I would suggest converting the queried data to the desired custom data type as that eliminates the usage of conversion functions on individual columns in the CDT which is not a great idea.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 7 years ago

@shaoyongw As explained above by other practitioners, you may need to depend on type casting where you may use Conversion Function todate() or you may also use typeof() in combination with cast() on the data_array.

Just in case, if the data_array is an output of the queryEntity, I would suggest converting the queried data to the desired custom data type as that eliminates the usage of conversion functions on individual columns in the CDT which is not a great idea.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data