How to Convert text to Date & Decimal

raveendran.s

Hi,
I need to convert a text value to a Date & also text to decimal. Please help me how to do it[/b]

easabangan

Text to date

txtVariable := '010107';
EVALUATE(dateVariable, txtVariable);
MESSAGE(FORMAT(dateVariable));

Text to decimal

txtVariable := '123.45';
EVALUATE(decimalVariable, txtVariable);
MESSAGE(FORMAT(decimalVariable));

kine

I will just correct the code to "clean" code... ;-):

txtVariable := '010107';
EVALUATE(dateVariable, txtVariable);
MESSAGE('%1',dateVariable);

and

txtVariable := '123.45';
EVALUATE(decimalVariable, txtVariable);
MESSAGE('%1',decimalVariable); 

And do not forget that somewhere is the '.' used as decimal point and somewhere ','. And that somewhere you can have ',' as thousand separator.

Asallai

I'd like to note, you can catch the exception, for example:

IF EVALUATE(dateVar,txtVAR) THEN ;

I think at this point you can catch the process if the convert does not work.