|
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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.