I am currently using the Advanced Find in CRM 2011, and I can't seem to find a way to filter a Date field that is before a certain date. The closest operator that I could find was "on-or-before", but I need it to be before that date and not on it.
Asked
Active
Viewed 2,289 times
0
-
so use on-or-before an put the date minus a day – Guido Preite Jul 11 '14 at 19:48
-
@GuidoPreite That is an alternative solution. If possible, I would like to use a before operator. I wanted to check to make sure I didn't miss it in my search. – dalawh Jul 11 '14 at 19:53
-
Its described here http://www.crmanswers.net/2013/05/on-or-before-and-on-or-after-conditions.html – minohimself Jul 11 '14 at 20:43
-
@minohimself I already looked at that previously. If I am not mistaken, that doesn't solve my issue at hand. – dalawh Jul 11 '14 at 21:31
1 Answers
0
I use lt (less than) if I need to do it by time. Presumably you can use gt too.
<condition attribute='scheduledstart' operator='lt' value='2015-03-16 10:29' />

Bob Hatcher
- 101
- 1