Sunday, April 17, 2011

Add Days to Date in OAF

 
import oracle.jbo.domain.Date;
import java.util.Calendar;
import java.text.SimpleDateFormat;
import java.text.ParseException;

String initDate =selectedRows.getAttribute("InitDate")+"";
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Calendar c = Calendar.getInstance();
String tatDate=null;
try
{
c.setTime(sdf.parse(initDate));
c.add(Calendar.DATE, 1); // number of days to add
tatDate = sdf.format(c.getTime()); // dt is now the new date
System.out.println("New Date : "+tatDate);
}
catch (ParseException e)
{
throw new IllegalArgumentException("Encountered Date format error "+ e);
}

Calculate the difference between two Dates in OAF

 
Date StartDate= (Date)CurrentRow.getAttribute("StartDate");
Date CurrentDate = (Date)am.getOADBTransaction().getCurrentDBDate();
java.sql.Date sdate = (java.sql.Date) StartDate.dateValue();
java.sql.Date cdate = (java.sql.Date) CurrentDate.dateValue();
int days = daysBetween(sdate,cdate );

public int daysBetween(java.sql.Date d1, java.sql.Date d2){
return (int)( (d2.getTime() - d1.getTime()) / (1000 * 60 * 60 * 24));
}

Friday, April 8, 2011

Add New Row in Advanced Table in Editable Mode

Making the Table Rows Read-Only - Gyan