Re: Progress Date Functions?

#1

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?

Thanks,
Dan

-------- 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
Newsgroups: comp.databases.progress
References: <9JFne.1854$hI3.1125 (AT) news (DOT) uswest.net>
<BHJne.19865$tv3.15669@trnddc06>
<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

Quote:

To determine the date range for the last 3 full months. It works like a
charm with SQL Server.

Steve Foley wrote:

Take a look at the following progress functions:

YEAR (D)
MONTH(D)
DAY(D)
DATE(X,Y,Z)

I have no idea what a dateadd function, or a convert function
does. I'm
guseeing getdate() is current date.

What are you trying to accomplish?

"Dan" <dan (AT) nospam (DOT) com> wrote in message
news:9JFne.1854$hI3.1125 (AT) news (DOT) uswest.net...

What is the equivalent Progress to this SQL Server:

(Invoicedate > = dateadd (m, -3, convert (char(6), getdate(), 112) +
'01')
AND (Invoicedate < convert (char (6), getdate(), 112) + '01'))

TIA,
Dan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Progress Date Functions?

comp.databases.progress comp.databases.progress

Re: Progress Date Functions? - 07-06-2005 , 04:20 PM