Jump to content

Portal Filter By Months Ahead Of Current Date


laguna92651

This topic is 2397 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I currently have a portal that I am filtering with 3 different global fields, all work fine. I would like to add a field to filter by a months block from current date. There is a sale date column in the form of 8/29/2017.

The date drop down filter field would have the following entries. The filter will be referenced to the current date.

If "3-6 mos" were selected only records in Dec 2017, Jan 2018 and Feb 2018 would show ( 3, 4 and 5 months from today's month).

This would be the drop down.

All Dates
< 0 mos
0-1 mo
0-3 mos
3-6 mos
6-9 mos
9-12 mos
>12 mos

This is what I currently have with the date filtering, using a custom function, this works fine.

( T20_ALL_OPPORTUNITIES::g_search_probability = 0
 or
T20_ALL_OPPORTUNITIES::g_search_probability   ≤  T20_ALL_OPPORTUNITIES::Sale_Probability )
 and
( T20_ALL_OPPORTUNITIES::g_search_priority = "All"
 or
FindWordPartsInText ( T20_ALL_OPPORTUNITIES::g_search_priority ; T20_ALL_OPPORTUNITIES::Priority ; 1 ))
 and
(IsEmpty ( T20_ALL_OPPORTUNITIES::g_search_opportunity )
 or
FindWordPartsInText ( T20_ALL_OPPORTUNITIES::g_search_opportunity ; T20_ALL_OPPORTUNITIES::Opportunity & ¶ & T20_ALL_OPPORTUNITIES::Account ; 1 ))
Link to comment
Share on other sites

I see two separate questions here. The first one is how to extract the two numbers from the value selected in the drop-down. The second question is how to use them in a filtering expression. The first question is actually the more difficult one, esp. since you have values that break the pattern (and will also require a different filtering expression).

To answer the second question, you could do something like:

Let ( [
start = ...................... ;
end = ....................... ;
startDate =  Date ( Month ( Get ( CurrentDate ) ) + start ; 1 ; Year ( Get ( CurrentDate ) ) ) ; 
endDate =  Date ( Month ( Get ( CurrentDate ) ) + end ; 1 ; Year ( Get ( CurrentDate ) ) )
] ;
startDate ≤ PORTAL_TO:YourDatefield
and
PORTAL_TO:YourDatefield < endDate
)

 

Link to comment
Share on other sites

Thanks for the expression it worked great, only had to had a plus 1 to the end date to include last month. To extract the month numbers just created a dropdown with the selection list, then a script with if statements to set the Start/End fields that are used in your expression. Thanks again.

image.png.02d4841fe75e3ca105fb0099019376b0.png

 

Link to comment
Share on other sites

This topic is 2397 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.