Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi. I am trying to find the number of quotes that started after the current date selection ( I have a calendar set up). The expression I use is Count({<StartTime= {">=$(getFieldSelections(eventDate))"}>} StartTime). I checked that getFieldSelections(eventDate) returns the correct date selections (say 6/4/2020). However, this expression returns 4 instead of 7
But I am trying to find the fields with a start date after the date picked by the user, and not necessarily the max of all dates
then try below
may be try creating variable and use it in set analysis
Create variable on front end as vMaxDate and put below expression
= date(getfieldselections(eventDate))
Now you can use your actual expression as below
Count({<StartTime= {">=$(vMaxDate)"}>} StartTime)
when a date is picked in the frontend, are all the calculations based off of the data that is related to that date? Like if I pick 6/4/2020, then the data that it searches through are the ones linked to 6/4/2020 (since that is what the filter does)?
yes. that's correct.
then is it still possible to search through all the data (not just the ones that relate to the date selection) to find those that are after the date selection?
yeah. you can do that as well.
Can you tell me how?