Converting number to data

[ts04]

Hi all!

Using CR 9.0

I would like to convert my date field (number) like: 20040714 into a real date field.

How do I do this. I can't seem te get it to work.

Thanx for the help in advance!

Tanja

 

[vidru]

Use a formula that converts the number to text, then pick out the parts of the string to turn it into a Date field:
[tt]
StringVar Temp := totext({Table.NumericDateField}, 0,"");
Date(Val(Temp[1 to 4]), Val(Temp[5 to 6]), Val(Temp[7 to 8]));
[/tt]
-dave