convert char field value into currecy field ?
Can any one tell me how to validate and convert char field value into currency field value?
I have a currency field which has char data element, so if I we pass the currency value in that field I need to validate that field value? (like it should be in the format of 101.22 regular currency format, and if any thing other than that then I need to send error message.
For example if the field value has - 101..22 or 101. 4 or any other format i need to send the message.
Can any one help me on this issue?