• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

Select data one year from Run date

Good morning!
Here's an interesting question (or so I think it is!)

We need to include records where the data is one year out from the date that the report is run.  For example, If I ran a report on April 1, 2012, it would include data from 12 months prior to that run date.

Not sure how to go about this - any ideas would be greatly appreciated!
Thank you -
cs
0
rporter45
Asked:
rporter45
  • 2
1 Solution
 
mlmccCommented:
Try this as the selection formula


{YourDate} >= DateAdd('yyyy',-1,CUrrentDate)

mlmcc
0
 
rporter45Author Commented:
Thank you - I'll try this now and get back to you,

cs
0
 
rporter45Author Commented:
Easy to translate into report.  Worked!
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now