Wednesday, July 31, 2013

Crystal Reports : Week Number and Date Functions

Most reports use some kind of date math or date grouping (i.e dollars per month, week, etc).
Let us suppose we need to return the week "number" within any given year based upon a simple date. (Our fieldname will be {SALES.SALEDATE})

The DATEPART() function is what we need here:

DATEPART("ww", {SALES.SALEDATE}, crSunday)

1. The "ww" specifies that we want the "week number" returned.
2. {SALES.SALEDATE} is the date field to evaluate.
3. The final parameter, crSunday, specifies on what day the week starts.

1 comment:

Anonymous said...

So,for the a lot of breitling replica part,aggregate we paid while application the millions involving for your just superior section accounts and aswell now we just absorb the money for money for what we'll get complex in return.Fake Cartier Watches that is included in best chic and authority are absolutely benign accumulating agencies that deserve to omega replica be captivated admitting an impressive.So you charge be actual accurate with the superior if you are traveling to buy one.People generally accept such a confounding that the added big-ticket the bigger quality.You should bethink that the a lot of acceptable one may not amount the most.If the amount ambit is reasonable,the appearance needs to gucci replica be taken into consideration.The appearance of replica accoutrements should be in band with your personality and taste.There is a array of replica handbags accessible in the market.The amount and superior alter a lot.You accept to be actual alert if selecting a absolute bag.Here are some tips to acquaint the difference.You can try hermes replica the bag by putting some abundant books into it and testing the backbone of the decorations as able-bodied as the adroitness of louis vuitton replica linings.So you can abrasion it about boondocks and be appreciative of your apish Ysl product.No one can apprehension the aberration bwtween the replica Ysl handbags and the aboriginal ones at aboriginal glance,or even at few glances.