Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Report to show last 10 days record

Author  Topic 

Shoaib62
Starting Member

1 Post

Posted - 2012-02-28 : 02:06:57
Hi All
i want to generate a report by using SQL Query in infomaker for the last 10 days from the current date ( date when report is going to be print)

table name is "sbmt"
filed name is "latest_recvd_date"

Remember in infomaker the available function are :

date( s ), today() , datetime( s ) , daysafter( d, d )

NOT ABLE TO USE getdate(),dateadd()


Thanks for all who are taking intrest for this solution

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2012-02-28 : 02:09:52
you should post this in the infomaker forum. This is MS SQL Server forum


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -