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


  1.  Home
  2. MIDRANGE-L
  3. March 2003

Re: Query calc # days

Gail,

sorry - this one actually works - I promise!

D1          substr(digits(s1busdat),2,2)||'/'
            ||substr(digits(s1busdat),4,2)||'
            /'||substr(digits(s1busdat),6,2)

D2          substr(digits(s2busdat),2,2)||'/'
            ||substr(digits(s2busdat),4,2)||'
            /'||substr(digits(s2busdat),6,2)

DAYSDIFF    days(date(d2)) -
            days(date(d1))

giving query results:

 S1BUSDAT   D1         S2BUSDAT   D2           DAYSDIFF
  990,115   99/01/15    991,001   99/10/01          259
  991,231   99/12/31  1,000,101   00/01/01            1
  991,230   99/12/30  1,020,101   02/01/01          733
1,020,101   02/01/01  1,020,201   02/02/01           31

sorry for previous bad directions :)

Rick

As an Amazon Associate we earn from qualifying purchases.

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