i have some problems on how to compare the DATE.
for example,i use the below code to get the today DATE.
java.util.Date today = new java.util.Date();
SimpleDateFormat datestr = new SimpleDateFormat("yyyy-MM-dd");
String today_date = datestr.format(today);
then,i have another DATE which is stored in the database.
lets say the DATE that i stored in datebase is database_date.
so now i would like to check whether database_date is 40 days older
p/s: the date format in the database(PoINTBASE) is yyyy-mm-dd