Advanced Filter - End Date between next 30 and 60 days

(0) Share

Report

Posted on by handedee

184

Hi,

How do I extract all records with end date between next 30 and 60 days in Dynamics CRM Advanced Filter?

Thanks

Categories:

Other

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Dynamics365 Rocker 7,755 on at

Like (0)

Report

RE: Advanced Filter - End Date between next 30 and 60 days

Try condition that is in attached screen shot:

Was this reply helpful? Yes No
handedee 184 on at

Like (0)

Report

RE: Advanced Filter - End Date between next 30 and 60 days

Hi,

Thanks for replying.

I am planning to create a view based on the above mentioned condition and add this view to a dashboard. Hence, I do not want to hardcode the date.

Thanks.

Was this reply helpful? Yes No
Dynamics365 Rocker 7,755 on at

Like (0)

Report

RE: Advanced Filter - End Date between next 30 and 60 days

Then check;

End date Next X days =60

End date next X days=30

Was this reply helpful? Yes No
handedee 184 on at

Like (0)

Report

RE: Advanced Filter - End Date between next 30 and 60 days

Hi,

I'm sorry, but isn't the function "Next X days" with respect to the current date? Next X days = 60 will give me all assets with end date in next 60 days, while Next X days = 30 will give me all assets that will end in next 30 days.

If I use a GROUP AND in this case, it gives me only records with end date in next 30 days. But what I'm trying to achieve is records with end date between next 30 and 60 days

Cheers

Was this reply helpful? Yes No
Suggested answer

Oksana Danyliak on at

Like (0)

Report

RE: Advanced Filter - End Date between next 30 and 60 days

You can try to achieve this with small customization.

Create calculated field: New Field="Due date - 30days", and use it in advanced find as New Field=Next 30 days.

Was this reply helpful? Yes No