Date format to pass parameter

sumathra

<p>Hi i had a oracle databases <strong>params["Date"].value</strong> as Date type in that value contain like <strong>2014-03-01</strong> so now i have to append in dataset like  <strong>"</strong><span style="font-size:14px;"><strong>BirtDateTime.month(params["Date"].value)"</strong>  it pass to query like <strong>"3"</strong> but i have to pass to  like<strong> </strong></span><strong><span style="font-size:14px;">'MAR' </span></strong><span style="font-size:14px;">so how to Extract string and pass to query</span></p>

minthril

<p>Hello sumathra!
I am not sure if I understand correctly byt maybe it will help you (or at least bring someone wiser to correct me ).

Try something like this in expression (little changes needed to fit 3 char long):

var monthNames = [ "January", "February", "March", "April", "May", "June",
  "July", "August", "September", "October", "November", "December" ]
x = monthNames[(params["Date"].getMonth())]

Hope that helps you

Best regards,
minthril</p>