How to Convert text to Date & Decimal

raveendran.s · 2007-09-20

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

easabangan · 2007-09-20

Text to date

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

Text to decimal

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

kine · 2007-09-20

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 · 2007-09-22

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.

Comments