Advance Find - On or After Today Date

(0) Share

Report

Posted on by winnipeg

205

Hello,

In the Advance Find, for any date field, is there a way to specify Today date as the filter? For example, if I want to return all opportunities that are created on or after today, instead of actually enter 02/23/12 for today and tomorrow, I have to go in and update the query again to 02/24/12 and so on. I want the date to default to today date instead of manually update it everyday.

Thanks,

Howard

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

jlattimer 24,562 on at

Like (0)

Report

Could you use the "Group OR" functionality? You could as your first criteria select Created On -> Today. Then for the second criteria select Created On -> Tomorrow (or Next X days or something else). Then select both rows but using the arrow at the front of the row and pick Group Or from the top and the query should return results that meet either of those criteria.

Was this reply helpful? Yes No
winnipeg 205 on at

Like (0)

Report

Thanks Jason for the replied. This does not return what I want though, since the Created On = Today or Created On = Tomorrow only return today or tomorrow records. Probably created date as an example is not a good one, I have a field in the Opportunity screen call Expired Date and I want all records expired today and onward.

Thanks

Howard

Was this reply helpful? Yes No
Verified answer

jlattimer 24,562 on at

Like (1)

Report

Could you use Expired Date = Today OR Expired Date = Next X Years where X = 100? I tested this with Opportunity Estimated Close Date it it brings back ones closing today and all the ones in the future.

Was this reply helpful? Yes No
winnipeg 205 on at

Like (0)

Report

Thanks Jason. I think that would do.

thanks again for all your help.

Howard

Was this reply helpful? Yes No
hicham 215 on at

Like (0)

Report

great!! helped me as well!!

Was this reply helpful? Yes No
MaJo 395 on at

Like (0)

Report

Hi Jason,

I want a filter which will bring all the past item. (Where DateTo <Today()) . HOw do I create this filter in my view?

Mathew Joseph

Was this reply helpful? Yes No
MaKeer on at

Like (0)

Report

Hi Jason,

I wanted to retrieve the records which are having StartDate after Now. That means it should compare the StartDate upto minute level. With using "Today" it compares just a Day. I can't even use "Next X Minutes" because there is no such comparison available.

Any suggestions how to write Advance find query for such scenario?

Thanks

Was this reply helpful? Yes No