How to filter crm view records for created on yesterday & day before yesterday.

(0) Share

Report

Posted on by SahilSharma

How can i filter crm datetime column in view with created on yesterday & day before yesterday. It should not report today's or later records.

E.g. Today is 21 Jan, then it should give records from 19 Jan & 20 Jan.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

FabioG 130 on at

Like (0)

Report
Copy link

Link copied!

the fetch on the view can be something like:

<fetch>

<entity name="entity-you-need" >

<filter type="and" >

<condition attribute="parameter-you-need-to-check" operator="olderthan-x-days" value="1" />

<condition attribute="parameter-you-need-to-check" operator="last-x-days" value="3" />

</filter>

</entity>

</fetch>

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Please try the below fetchxml.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

<entity name="contact">

<attribute name="fullname" />

<attribute name="telephone1" />

<attribute name="contactid" />

<order attribute="fullname" descending="false" />

<filter type="and">

<condition attribute="createdon" operator="yesterday" />

<condition attribute="createdon" operator="last-x-days" value="2" />

</filter>

</entity>

</fetch>

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!

Try with this , i just checked only condition "Last 2 days" should work for you.

Here is the FetchXML

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="contact">
<attribute name="fullname" />
<attribute name="telephone1" />
<attribute name="contactid" />
<order attribute="fullname" descending="false" />
<filter type="and">
<condition attribute="createdon" operator="last-x-days" value="2" />
</filter>
</entity>
</fetch>

Was this reply helpful? Yes No
Suggested answer

SahilSharma 35 on at

Like (0)

Report
Copy link

Link copied!

I was able to achieve by above. Thank u all.

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!

I don't see any reason to add multiple condition here , you can simply put condition Last X days = 2 . See my answer .

Did you check my suggestion?

Was this reply helpful? Yes No
FabioG 130 on at

Like (0)

Report
Copy link

Link copied!

he is looking for the last 2 days but not today. So he needs that condition

Was this reply helpful? Yes No