Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...
SQL Server Forum / Services / Analysis (Data Mining) / October 2004

Tip: Looking for answers? Try searching our database.

Thread preview
Titles only
Unanswered
Popular
ThreadLast Post  Replies
Week values rolling over to new year. Help?02 Oct 2004 02:03 GMT1
I have a report which shows quantities of items shipped in the 4 weeks prior
to the date selected. Here is the formula I am using to calculate 1 week
prior to the date parameter:
If ({?ParamWeek}-1) <= 0 Then ({?ParamWeek}+52) Else ({?ParamWeek}-1)
Pages: 1 2 September, 2004
2009DecNovOctSepAugJulJunMayAprMarFebJan
2008DecNovOctSepAugJulJunMayAprMarFebJan
2007DecNovOctSepAugJulJunMayAprMarFebJan
2006DecNovOctSepAugJulJunMayAprMarFebJan
2005DecNovOctSepAugJulJunMayAprMarFebJan
2004DecNovOctSepAugJulJunMayAprMarFebJan
2003DecNovOctSepAugJulJunMayAprMarFebJan
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.