Re: Query400 question

["Bill Robins" <brobins3d@xxxxxxxxx>]

Claudia,

It can be done.  It's a bit obtuse and has a couple of restrictions.  I had
never done it before now when I tested it.  The logic is actually quite
simple.

Turn the character field into the microseconds portion of a time stamp.
CCUSTN        microsecond('2000-02-18-01.01.01.' || CCUSTA)

In this example, CCUSTA was created by Digits(CCUST).  Obviously, any combo
will do.  I think I have heard the restrictions are that the number must be
a whole number in the range of 0 to 999999.

Bill

(I did a full article about the date calculation capabilities in Query in
Midrange Computing around 1995, if you have some old issues look it up)

> Bill,
> very interesting your instructions for Date manage with Query/400.
> One more question: don't you know if there is a keyword in query that
allow
> me to convert an alphabetic field in a numeric ? (something opposite to
the
> keyword DIGITS).
> Thanks
> Claudia



__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---