[ASK] what function to see start and end of custom days-group ?

[#1]

hello..

i've made a days-group field in edit script with this syntax :

if(weekday(mst_date)<>'Sunday' and weekday(mst_date)<>'Saturday',date(floor(mst_date/3)*3)) as threedaysgroup

and the issue that shows up is how to see start day of group and end of group?

example,

threedaysgroup | startdate | enddate

====================================

03-Jan-2010 | 01-Jan-2010 | 03-Jan-2010

06-Jan-2010 | 04-Jan-2010 | 06-Jan-2010

.

.

.

many thx...

[#2]

hi please use

this funcation

networkdays (mst_date )

it give no of working day exclude Saturday and Sunday.

according no of day you make 3 day group.

Regards

Ashish

[#3]

hello Ashish..

i've tried that, and it shows no data