Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I need to create action button to select first/last N number of month values in my sheet.
To select value before/after specific date, I have created Text box and added Action(Selection->Select in Field) and used below expression in "Search String" place
='(' & Concat(DISTINCT {<Month = {">=11/01/2020"}>} Month, '|') & ')'
This is working for highlighted fixed value. I have created variable and trying to replace with fixed value. it is not working.
VFMonth=Pick(InputMonth,'10/01/2020','11/01/2020','12/01/2020') //Created variable
='(' & Concat(DISTINCT {<YYYYMM01 = {">=" & VFMonth& ""}>} YYYYMM01, '|') & ')'
Note: i am using personal edition. Hence request you to not upload .QVW files
Please support.
Hi
Try like below
='(' & Concat(DISTINCT {<YYYYMM01 = {">=$(VFMonth)"}>} YYYYMM01, '|') & ')'
Make sure, date format is same like ur field.
Hi
Try like below
='(' & Concat(DISTINCT {<YYYYMM01 = {">=$(VFMonth)"}>} YYYYMM01, '|') & ')'
Make sure, date format is same like ur field.
Hi Mayil Vahanan,
Thanks for your quick solution.