Current system date 2

[anilcognos]

Hi
I was trying to import a table from progress database to sql server Using DTS.

select "Tablename"."Name","Tablename"."Address",
"Tablename"."Date"

from "Tablename" where "Tablename"."date"=Date ('01-08-2002')


This worked fine. However I want to run this report everyday
to capture all the data for the current month

select "Tablename"."Name","Tablename"."Address",
"Tablename"."Date"

from "Tablename" where Month("Tablename"."date&quot=
Month(today())


so i need a functionality similar to Month(today())

which i snot there, can any one help.


Anil

 

[franklin1232]

I am not very fimilar with DTS. I probally would have written a progress 4GL app, but here is my 2 cents. I hope you are using a newer version of progress with a decent SQl92 driver. version 9.1c was the first version to ship with a decent ODBC driver. Pick up the SQL 92 guide. You might find the Month() function helpful. Check page 4-67 and 4-68.

http://www.progress.com/v9/documentation/start.htm#sql_92.htm

let me know if this helps.

 

[Natalie]

The TODAY equivalent for SQL server is getdate():
month("tablename"."date&quot = month(getdate())

Hope this helps!

Natalie