Variable value in Concat distinct field

[kasmurugesan]

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.

[MayilVahanan · Accepted solution]

Hi

Try like below

='(' & Concat(DISTINCT {<YYYYMM01 = {">=$(VFMonth)"}>} YYYYMM01, '|') & ')'

Make sure, date format is same like ur field.

[kasmurugesan]

Hi Mayil Vahanan,

Thanks for your quick solution.