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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Previous Year 1

Status
Not open for further replies.
lewes

lewes

Technical User
Apr 7, 2008
14
GB
Hi, Help would be appreciated.

Using CR 9 is there a function I can put in a formula which means it calculates the date a year before? For example, if todays date is 09/04/08, I want the formula to produce 09/04/07.

Thanks
 
Sort by date Sort by votes
You could use:

dateadd("yyyy",-1,{table.date})

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TomPreston
  • Locked
  • Question
Previous Period Chart
Replies
1
Views
94
lbass
lbass
kate8
  • Locked
  • Question
How to do the first date of the year in command
Replies
2
Views
96
hilfy
hilfy
bdmoran
  • Locked
  • Question
Comparing Weeks By year
Replies
13
Views
116
bdmoran
bdmoran
Pookeye
  • Locked
  • Question
Next, Previous Function with Groups.
Replies
1
Views
132
kenhamady
kenhamady
mrpatak
  • Locked
  • Question
Previous() function not pulling previous record?
Replies
5
Views
102
kenhamady
kenhamady

Part and Inventory Search

Sponsor

Back
Top