Home : Grouping Year to Before Start Date Examples
Q10512 - INFO: Grouping Year to Before Start Date Examples

The following table shows the offset to use for common tasks when using Spread Grouping functions (GAVG, GSUM, etc...):

Grouping: "YTBSD" - Year to Before Start Date

Offset Description Dates(Report dates of 3/1/02 thru 3/31/02)
-1 Two years ago, YTD 1/1/2000 - 2/29/2000 (leap year)
0 One year ago, YTD 1/1/2001 - 2/28/2001
1 Year to Date 1/1/2002 - 2/28/2002
2 Next Year, YTD 1/1/2003 - 2/28/2003

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 10/5/2007 6:37 AM.
Last Modified on 10/5/2007 2:51 PM.
Last Modified by Scott Dorner.
Article has been viewed 3591 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article