Re: Previous Month function

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Wed, 18 Aug 1999 12:22:56 -0400
Message-ID: <37BADDE0.667CD2E2@Unforgettable.com>

Use add_months().

john bruin wrote:

> Does anyone know if there is a function to select records for the
> previous month. In the past we have run a query on the 1st day of the
> month and selected for the previous 31 days ("sydate -31") which is OK
> but requires sorting/deletion of unwanted records for the months that
> have 30 days or less.
>
> Any help appreciated,
> John
Received on Wed Aug 18 1999 - 11:22:56 CDT