Search all records created before 1-2 weeks ago?

Question

I'm trying to create a report based on opportunities. One stat I'd like to see is opportunities that were modified but were not created this/last week, so I can see how many old opportonities have been worked on.

However on setting the filter criteria, the closest thing I can get to is "Older than X months", which will show all records modified but created more than a month ago.
Correct concept, but I need this to be 1 or 2 weeks.

I don't want to use "on or before" as you have to set a specific date. I need this report to be dynamic.

Any suggestions?

Try to write a little more careful. Correct spelling, indentation, capitalization will make your question more interesting to read and answer. — Joris Van Regemortel, Jun 20 '13 at 11:33

score 2 · Answer 1 · answered Jun 20 '13 at 13:29

2

A possible solution is to make dynamic the date inside the On or Before condition.

You can follow this tutorial:

CRM Answers - "On or Before" and "On or After" conditions inside FetchXML Reports

answered Jun 20 '13 at 13:29

Guido Preite

14,905
4
36
65

score 0 · Answer 2 · answered Jun 20 '13 at 11:31

0

I suggest you just use "on or before", and then calculate the date at runtime, based on the current date.

answered Jun 20 '13 at 11:31

Joris Van Regemortel

935
1
10
34

Search all records created before 1-2 weeks ago?

2 Answers2