Playing with dates

anuradhaa — Tue, 03 Mar 2015 10:52:50 GMT

Hi,

i have a data set and it contains

start date and enddate.

see below

I have year select box and month select box and used end date in those select boxes.

when user select January,I need to display average difference based on below logic,

1. select records that has start date and end date on January and get the difference

2. If the record has started before January and end on January get the start date as jan 1 and calculate the difference

3. If the record started on January and end after January , consider end date as jan 31 and calculate thedifference.

4. If record started before January and end after January , consider start date as jan 1 and end date as jan 30 and calculate the difference.

This will depend on the selected month

so above table become like this

Is this possible and any one has and idea how to do this in scrip or UI.

Thanks

Re: Playing with dates

MK_QSL — Tue, 03 Mar 2015 11:17:10 GMT

Is below same?

anuradhaa — Tue, 03 Mar 2015 12:06:16 GMT

yes, no answers to previous one , so i posted it again with different topic