<p>Hi All,</p>
<p> </p>
<p>I'm using Oracle...</p>
<p> </p>
<p>I have a dataset that requires capturing data for the previous month.</p>
<p> </p>
<p>The user can enter current month, Month = 01 and Year = 2016, as input parameters.</p>
<p> </p>
<p>I'd like to be able to take the input from the user and convert the string values to to_date(input parameters, 'MM/YYYY'), but I don't believe I'm using the correct syntax.</p>
<p> </p>
<p>Within my dataset I currently have ...</p>
<p>where date_field < to_date(' " + params[Month] || '/' || params[Year] + " ', 'MM/YYYY')</p>
<p> </p>
<p>Is this the correct syntax for concatenating the input parameters and formatting them as dates ?</p>
<p> </p>
<p>Thanks</p>
