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

Re: date operations

Pedro

Look in the help for result fields. There i saw the CURRENT() function - you put the kind of data you want as the argument, so CURRENT(DATE) returns a DATE value, CURRENT(TIMESTAMP) a TIMESTAMP of this date. The "minus 1 month" works fine.

HTH

Vern

At 02:23 PM 1/10/03 +0000, you wrote:
Hi

Does anyone know if its possible to do date operations on query400?
For exemple, is it possible on a query do something like : current date - 1
month    (200301 -1 mont = 200212)

Cordialement,
Best regards,
-------------------------------------------------------------------
Pedro Reis
Information System
e-mail: pedro.reis@valeo.com
Phone: 351-258 350 725
Fax: 351-258 350060
--------------------------------------------------------------------
VALEO - Electronics & Connective Systems
Viana do Castelo - Portugal
--------------------------------------------------------------------























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.