convert data type

[Former Member]

Hi folks,

i'm facing a problem, when passing parameter to BAPI.

i have declare date as java.util.date, i need to change declaration to java.sql.date, anyone know?

[Former Member]

Chandan , i get an error message java.lang.IllegalArgumentException for java.sql.Date.valueOf, below is my code :

SimpleDateFormat sdf = new SimpleDateFormat ("yyyy-mm-dd") ;

String S_startdate = wdContext.currentContextElement().getStartDate();

String S_enddate = wdContext.currentContextElement().getEndDate();

java.util.Date D_startdate;

try {

D_startdate = sdf.parse(S_startdate);

S_startdate = sdf.format(D_startdate);

} catch (ParseException e1) {

e1.printStackTrace();

}

java.util.Date D_enddate;

try {

D_enddate = sdf.parse(S_enddate);

S_enddate =sdf.format(D_enddate);

} catch (ParseException e2) {

e2.printStackTrace();

}

java.sql.Date startdate = java.sql.Date.valueOf(S_startdate);

java.sql.Date enddate = java.sql.Date.valueOf(S_startdate);

do you know what's wrong with this?

[Former Member]

Hi,

Try using

SimpleDateFormat sdf = new SimpleDateFormat ("yyyy-MM-dd") ;

mm refers to minutes and not month.

[Former Member]

Hi,

Before executing the BAPI set the varaible date to sql date using following

Date sqlDate = new Date(utildate.getTime());

[former_member206397]

Hi,

I think this will help you.

import java.sql.Date;

import java.text.SimpleDateFormat;

import java.util.Date;

...

String dateString = "18/08/2005";

SimpleDateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");

java.util.Date d;

try {

d = dateFormat.parse(dateString);

dateFormat.applyPattern("yyyy-MM-dd");

dateString = dateFormat.format(d);

} catch (Exception e) {

e.printStackTrace();

}

java.sql.Date date = java.sql.Date.valueOf(dateString);

System.out.println(date);

Thanks and Regards

Chandan

[Former Member]

Hi,

You can convert java.util.date to java.sql.date. Do this conversion before calling the BAPI.

//say <i>date</i> is the "java.util.date" variable
java.sql.Date sqlDate = new java.sql.Date( date.getTime() );

Regards,

Satyajit.

[Former Member]

Hi,

can u explain me clearly.....did u write any code ?if there post me.....