Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

a filter

2 posts in PB Infomaker Report Writer Last posting was on 1999-05-14 23:23:25.0Z
Richard Posted on 1999-05-14 18:38:18.0Z
Newsgroups: sybase.public.infomaker.general
From: "Richard" <georgehills2@worldnet.att.net>
Subject: a filter
Date: Fri, 14 May 1999 11:38:18 -0700
Lines: 7
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_IdWVLjjn#GA.270@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6319
Article PK: 241305

I would like to specify a filter that would only capture records that have a
closed_date of five years or less than the claim_reporting_history_end_date.
so... closed_date < ???? how would I finish the filter?


Terry Dykstra Posted on 1999-05-14 23:23:25.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: a filter
Date: Fri, 14 May 1999 17:23:25 -0600
Lines: 21
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_Z74HABmn#GA.270@forums.sybase.com>
References: <348_IdWVLjjn#GA.270@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6318
Article PK: 241304

Something like: daysafter( closed_date ,
claim_reporting_history_end_date) > 5 * 365
Depending on how many rows your are pulling, you might want to do this in
your Select statement. You'll have to use the date functions specific for
your DBMS.

--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Richard wrote in message ...
>I would like to specify a filter that would only capture records that have
a
>closed_date of five years or less than the
claim_reporting_history_end_date.
>so... closed_date < ???? how would I finish the filter?
>
>
>
>