Advanced Filter using the Date criteria - Before Today

(0) Share

Report

Posted on by CindiRella

195

In the Advanced Filter there are many options when using a date field. I want to pull all Leads that are created before TODAY. There is the On or Before and then you have to specify a specific date. I do not want a "hard coded" date, but always to show everything created before TODAY. Is there a way to do this in the Advanced Filter??

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (1)

Vile Andreas Rantala 1,257 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I think you should use in your advanced find, Creation Date = Last X Hours or Last X days with that you could see the leads created before Today.

I hope this helps.

Regards :)

Was this reply helpful? Yes No
CindiRella 195 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately that still includes today's date.

Was this reply helpful? Yes No
Vile Andreas Rantala 1,257 on at

Like (0)

Report
Copy link

Link copied!

Ok, then use Creation Date = LastDay.

Was this reply helpful? Yes No
CindiRella 195 on at

Like (0)

Report
Copy link

Link copied!

Again that will not work because it includes TODAY's data. I don't want that included in the data that is returned.

Was this reply helpful? Yes No
Verified answer

Guido Preite 54,086 Moderator on at

Like (0)

Report
Copy link

Link copied!

A filter "before today" is not available for DateTime fields.

You need to specify the date or create a boolean field to mark today's leads (and run daily an update when they get old) in order to perform your query.

Was this reply helpful? Yes No
Aileen Gusni 44,524 on at

Like (0)

Report
Copy link

Link copied!

Hi Cindi,

Out of the box view in CRM does not have this filter criteria.

You should create a custom view, see this:

social.microsoft.com/.../how-to-create-a-custom-view-showing-older-than-x-days-ms-dynamics

THank you.

Was this reply helpful? Yes No
CindiRella 195 on at

Like (0)

Report
Copy link

Link copied!

Thanks, that was what I though. Would be nice if I could just type BEFORE TODAY.

Was this reply helpful? Yes No
Suggested answer

MaJo 395 on at

Like (0)

Report
Copy link

Link copied!

What I would do is select "Last x Days" filter and enter value something like "365".

This would bring all the items in last 365 days for that date field.

Mathew

Was this reply helpful? Yes No
lawix10 334 on at

Like (0)

Report
Copy link

Link copied!

Wow almost 3 years after and Microsoft did not fix this issue permanently,

Am trying to create a view for past members.

So the date should be before today.

please how do I do that.

Regards.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

This may help you.

msdn.microsoft.com/.../hh179519(v=nav.90).aspx

Was this reply helpful? Yes No