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
rporter45Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.