× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: Query400 question
  • From: "Bill Robins" <brobins3d@xxxxxxxxx>
  • Date: Fri, 18 Feb 2000 08:40:21 -0800

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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.