how to use presentation vaiable in direct db request for date in between

 Use presentation variable in direct db request for date in between


Use below format for between filter in direct db request in OBIEE.
Here v_date is presentation variable

to_char(trunc(day_dt),'YYYY-MM-DD') between substr('@{v_date}{2001-01-01}',1,instr('@{v_date}{2001-01-01,}',',')-1)
AND SUBSTR('@{v_date}{2020-01-01}',INSTR('@{v_date}{2020-01-01}',',')+1 )