Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backdating Calculations

Status
Not open for further replies.
pddp

pddp

Technical User
Joined
Sep 13, 2012
Messages
1
Location
US
I want to create a report that automatically creates as of run date but for a range four years ago. What Calculation Definition should I use? For example I want to do 08/01/2008 to 04/04/2009 (cur date but four years ago). Make sense? Thanks.
 
Sort by date Sort by votes
With Report Studio:

_add_years (current_date,-4) yields 2009-4-4 for current_date = 2013-4-4



Ties Blom

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

wernmatt
  • Locked
  • Question Question
Where to do SQL-Calculations
Replies
1
Views
133
blom0344
blom0344
UcfMike
  • Locked
  • Question Question
Date Calculations
Replies
3
Views
180
blom0344
blom0344
atomictortoise
  • Locked
  • Question Question
Calculations in Report Studio
Replies
2
Views
156
atomictortoise
atomictortoise
rjhrrs
  • Locked
  • Question Question
Metrics Calculations - Dividing by statistical data.
Replies
0
Views
90
rjhrrs
rjhrrs
CognosTalk
  • Locked
  • Question Question
Calculations stopped working in Report Studio
Replies
2
Views
131
CognosTalk
CognosTalk

Part and Inventory Search

Sponsor

Back
Top