How to find the date difference values

[ravindraa]

Hi all ,

  i have struck one place please help me  to get solution.

My requierment is officer enter his present on dily basis some time he take lave , in my app i have to caliculate how many day perticular officer take laeve what are those days and based on the FROMDATE  to TODATE.

1.how many days officer present

2.how many days offcer take leave

3.how many days he didnot punch (Null value) .

above caliculation i have to show one chart i have wrote one logic but It is not selecting FROM DATE AND TODATE selction  as well as i t is not givine the in the list of presented dates , leave date.

please give me suggeson on this.

Please find the attachments.

Thanks in advance...,

[MK_QSL]

Check the enclosed file...

[ravindraa]

Hi Manish Kachhia,

  Thanks for replying but the values are not reflecting based on the dates selection (min date and max date) the values has to display based on the selection wise, could you give me any suggesion on this.

Thaks in advance..

[ravindraa]

Hi,

experts please help me on this issue,