Date calculation

[2005 IR Help]

By: gavich - gavich

Date calculation

2004-06-03 02:58

Hi,

 

I display two dates in my report and I would like to display the duration between the two.

How could i do that?

 

I tried to compute it in my sql querry but ireport throw an error.... in my querry i have (end_date-begin_date) but the field name cause a sax exception (not a token).

 

please help

 

thx

 

 

 

 

By: Lucian Comanescu - lucicom

RE: Date calculation

2004-06-03 03:56

Hi!

 

You can use: $F{end_date}.getTime() - $F{begin_date.getTime()} ... you'll obtain a "long" with the miliseconds diference between the 2 dates.

 

Lucian.