Hi, I have a query that summerize a file and makes a new-file. In this new file i have a field breaklvl and a total-value of a field. Can someone tell me if it is possible to convert the content of the field 'breaklvl' of the query400 into a numeric (Ex 2,0) value using Query400 ? I tought it could be done by using a new-defined field using something like microseconds, but i can not remember me how to do it ?
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Convert characters to numeric with query400
Collapse
X
-
Convert characters to numeric with query400
Doeraene Jean-Pierre wrote: > Can someone tell me if it is possible to convert the content of the > field 'breaklvl' of the query400 into a numeric (Ex 2,0) value using > Query400 ? I tought it could be done by using a new-defined field > using something like microseconds, but i can not remember me how to > do it ? This is the syntax: microsecond('2000-02-18-01.01.01.' || charfieldname) The first part is just any date time stamp then follow it with a character field. Bill
Comment