title: SETVERIABLE not working in informatica
body: <p>i have a senerio where i need to get the previous month data.
   so i created two flows in the mapping flow 1 will get the dates of first and last months and i am using parameter veriables and calling them in  mapping 2  in source sql, but for some reason the sql is not taking the parm vlaues, even after the vlaues are there in it.</p>
  
  <pre><code>SETVARIABLE($$END_DATE,set_$$END_DATE_v)   ----------------------
  </code></pre>
  
  <p>this the condition i am using to get the $$END_DATE(  which is set in paramters), so iam getting end date as 20160930
  and in the source sql i said:
   <code>PAL.EXCLS_PAID_DATE BETWEEN  TO_DATE($$START_DATE,'YYYYMMDD')  AND  TO_DATE($$END_DATE,'YYYYMMDD')</code>,
   but its returing 
  <code>PAL.EXCLS_PAID_DATE BETWEEN  TO_DATE(,'YYYYMMDD')  AND  TO_DATE(,'YYYYMMDD')</code> and throwing error as missing expression</p>