Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
I have a column with dates. There is a separate date filter. I want to show Max Date from dates column based on the date selected in the filter.
If the user select 31-DEC-2017 then it restrict the dates till 31-DEC-2017 and show the maximum date from first day till 31-Dec-2017.
If the user select 30-NOV-2017 then it restrict the dates till 30-NOV-2017 and show the maximum date from first day till 30-NOV-2017.
Suppose Date is in vDate and dates column is plan_start_date.
Regards,
Zahid Rahim
if the user select 30-NOV-2017; the max date will also be 30-NOV-2017.
The condition is way simpler than "restricting the dates from the start to the 30-NOV-2017.. since the max date is in fact 30-NOV-2017)
No?
Maybe I've missed understood some things
I've in fact misread.. there is 2 seperate date fields
edited
max({<plan_start_date={"<=$(=max(Date))"}>}plan_start_date)
Pradosh;
it's double quotes and not quotes (please refer to this Quotes in Set Analysis )+ u've ommited the $(=urMeasure)
max({<plan_start_date={"<=$(=max(Date))"}>}plan_start_date)
Hi Omar
Thanks for the correction. I have edited that now. Must be an off day for me and wrote the expression in a hurry. Generally i am the one who ask people to refer the same document.
Thanks
Pradosh