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 Mike Lewis 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
Sep 13, 2012
1
0
0
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
Where to do SQL-Calculations
Replies
1
Views
27
blom0344
blom0344
UcfMike
  • Locked
  • Question
Date Calculations
Replies
3
Views
34
blom0344
blom0344
atomictortoise
  • Locked
  • Question
Calculations in Report Studio
Replies
2
Views
33
atomictortoise
atomictortoise
rjhrrs
  • Locked
  • Question
Metrics Calculations - Dividing by statistical data.
Replies
0
Views
15
rjhrrs
rjhrrs
CognosTalk
  • Locked
  • Question
Calculations stopped working in Report Studio
Replies
2
Views
28
CognosTalk
CognosTalk

Part and Inventory Search

Sponsor

Back
Top