Use of many instructions inside a variable

[dboutin]

Hi,

Is it possible to use a script as this one inside a variable of iReport ?

 

java.util.Calendar calendar =

new java.util.GregorianCalendar();
calendar.setTime(new java.util.Date($F(My_Date)));
calendar.get(java.util.Calendar.YEAR); Regards,

 

Denis.
 

 

 

[sjongenelen]

yes, as long as make it in one line :)
make it easier on yourself to get the date from your DB as Date (field)
(new java.util.GregorianCalendar().setTime($F{date}).get(java.util.Calendar.YEAR)

perhaps you can make multiple variables to make it easier OR

try to use the SQL functions of your db... for example, i use the WEEK() function of MySQL:
select WEEK(customer.dob) as weeknumber_dob from customer

Post Edited by sjongenelen at 11/17/2009 15:29