Customer experience | Sales, Customer Insights,...

Fetch exactly 6 month older record from current date

(0) Share

Report

Posted on by Anandhcrm

Hi,

I am having a date field in a custom entity. I need to fetch exactly the 6 months older record by comparing that date field with the current date. How can I build the fetchxml ?

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report

Hi Anandhcrm,

You can resolve your problem by using the On or Before clause.

If I answer your question then please mark it as verified.

Let me know if I can provide you with more details.

Thanks
Regards,

Abdul Wahab
Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: www.linkedin.com/.../

Was this reply helpful? Yes No
Suggested answer

Ray 1,537 on at

Like (0)

Report

Hi,

Another way is to use the "olderthan-x-months" operator,

<condition attribute="<AttributeName>" operator="olderthan-x-months" value="6" />

Here is the doc

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

You need to select below condition in your fetchXml.

On or before - set value dynamically in your c# code by using below code

AddMonths(your custom field date value, -6)

Was this reply helpful? Yes No
Anandhcrm on at

Like (0)

Report

no.. I need like this..

for example, if I'm having the records in my entity like this..

name, joineddate

aaa, 12/04/2022

bbb, 13/04/2022

ccc, 14/04/2022

ddd, 13/04/2022

my fetchxml will give the records having the date exactly 6 months old of joined date

the result should be if the current date is 13/10/2022 are:

bbb, 13/04/2022

ddd, 13/04/2022

result should be if the current date is 14/10/2022 are:

ccc, 14/04/2022

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

Where do you want use this logic ?

In plugin, if yes then change operator to ON instead of on or before and pass the value as

AddMonth(DateTime.now(),-6).ToShprtDateString();

Was this reply helpful? Yes No