Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to convert a string to number?

Hi,

I want to display a text box when the date in another chart must be < 03/04/2013.

For that I wrote a code under the Layout -> Condtional Show of the Text box as below

=GetSelectedCount(Month_Date)<>0 or num(SubField(GetFieldSelections(Month_Date),',',-1))<41366

but the String returned from SubField(GetFieldSelections(Month_Date),',',-1) could not convert to number format.

Anyone please help me...

Thanks in advance

1 Reply
Anonymous
Not applicable
Author

It might be that your Month_Date value needs to be converted to a proper date format first (after parsing it from the field selections) before you can convert it to a number?