Re: Progress Date Functions? - 07-06-2005 , 04:20 PM
Just got back to this. I am using Brio to query a Progress 9.1 database
via ODBC. The below 'today' does not work. For example and to keep it
simple, I want to set a where clause as "EnterDate <= CurrentDate - 6
days". When I tried this using 'EnterDate <= curdate() - 6' I did not
get the expected results of 6/30/05. Can someone help me?
-------- Original Message --------
Subject: Re: Date Functions?
Date: Sun, 05 Jun 2005 19:02:40 GMT
From: Steve Foley <steve.foley (AT) DELETEatt (DOT) net>
Organization: AT&T Worldnet
References: <9JFne.1854$hI3.1125 (AT) news (DOT) uswest.net>
<stYne.16217$4u.1120 (AT) newssvr33 (DOT) news.prodigy.com>
<UzZne.14$BK2.500 (AT) news (DOT) uswest.net>
So if today is June 5, you want the date range to be March 1 to May 31?
The last day of last month would be
today - day ( today ).
The first day of three months prior to above date would be
date ( today - month ( today ) -65 , 1 , year ( today - day ( today ) -
65 ) )
"Dan" <dan (AT) nospam (DOT) com> wrote