If you make your year field into a date, i.e. 01-12-2017, etc... you will be able to use the filter type Range of Dates.
A formula like this should work:
MAKEDATE( INT(LEFT([Year], 4)), INT(RIGHT([Year], 2)), 01)
What it is doing is converting your year field (string) into a date by taking the first 4 characters (eg 2017) and making it into a year, taking the last 2 characters (eg 12) and making it into a month, and assigning 01 as the day (first day of the month). The INT function converts your string year field into an integer.
Hope this helps!
Hi Louise, Thanks for quick help!
I will try what have you suggested but..Actually in my existing SSRS report created the code like.. this functionality we are need to create in TABLEAU.
where to_char(bill_dt,'YYYYMM') >= substr(:SelectMonth,1,4) || '01'
AND to_char(bill_dt,'YYYYMM') <= :SelectMonth
here SelectMonth is a parameter but we don't want to like use parameter in CustomSQL.
any ideas for above requirement?