Hello, I'm trying to write a MS-DTS Script that will connect to my Oracle 8i server and download data for the last full month.

In my Table I have a table "SW_CASE" I have a column named: "SWDATECREATED".
It store the data the following way:

2004-09-02 08:57:12

What I need is a way to tell it I Only need the rows from the last full month. I don't want to have to change the date every time I co to run this query.

I've tried the following only to get a syntax error:

Code:
SW_CASE."SWDATECREATED" >= DATEADD(mm,DATEDIFF(mm,0,SYSDATE())-1,0) AND
SW_CASE."SWDATECREATED" < DATEADD(mm,DATEDIFF(mm,0,SYSDATE()),0))

Any Ideas?

Fishbone34