Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
max({1<month={'$(=month(vperiod))'}>}period))
vperiod is = getfieldselctions(period)
here period is 16/11/2014
Confusing, given what it seems to be doing, but from what I can tell:
A user makes a selection in the field 'period' and the value is passed to the variable vperiod.
The expression then returns the maximum period where the month field is equal to the month of the period held in the variable.
It'd be more helpful if you could mention what format the fields were both in and what the expression was being used for.
Thats fien aaron,
i understood now my req is
in period i have dates like
period:
11/26/2014
11/27/2014
11/28/014
but when i select 11/26/2014 even though above expression returning data for 11/28/2014 only
i want see for selected date
but i have in my expression MAX , i think because of this i am getting 11/28/2014
how to get current selected date period?
max({<month={'$(=month(vperiod))'}>}period))
remove 1 from the script.
try like this
=max({<month={$(=month(vperiod))}>}period)
Is there a reason you take the field selection, pass it to a variable, and then re-evaluate this?
What is the expression doing? Is it embedded in another calculation? Because if you just want to return your selected date, you can just use max(period)...