Date Difference

[Former Member]

How do we calculate difference between 2 dates.

Can someone help me with the code please.

[sridhar_k2 · Accepted solution]

Use this below method, which will return diff between dates.

wdComponentAPI.getMessageManager().reportSuccess("Diff : "+ wdThis.datesDiff(wdContext.currentContextElement().getDate1(),wdContext.currentContextElement().getDate2()));

public int datesDiff( java.sql.Date date1, java.sql.Date date2 )

{

//@@begin datesDiff()

Calendar cal1 = Calendar.getInstance();

Calendar cal2=Calendar.getInstance();

long ldate1 = date1.getTime() + cal1.get(Calendar.ZONE_OFFSET) + cal1.get(Calendar.DST_OFFSET);

long ldate2 = date2.getTime() + cal2.get(Calendar.ZONE_OFFSET) + cal2.get(Calendar.DST_OFFSET);

int date1Hr1 = (int)(ldate1/3600000);

int date2Hr2 = (int)(ldate2/3600000);

int days1 = (int)date1Hr1/24;

int days2 = (int)date2Hr2/24;

int dateDiff = days2 - days1;

return dateDiff;

//@@end

}

Regards,

SK

[raja_thangamani]

Refer this thread

Raja T

Message was edited by:

Armin Reichert