select distinct Day(Assn_Finish_Date) as EventswithDate from PMS_MileStones_Info where assn_rem_work=0 and task_id in (select max(task_id) from PMS_milestones_info group by proj_id) and month(Assn_Finish_Date) like '9' and Year(Assn_Finish_Date) like '2010'

    Web Based PMS Events Calendar
Date of Events in this Month are
 
<< September 2010 >>
Sun
 Mon
 Tue
 Wed
 Thu
 Fri
 Sat
      1

 2

 3

 4
5

 6

 7

 8

 9

 10

 11
12

 13

 14

 15

 16

 17

 18
19

 20

 21

 22

 23

 24

 25
26

 27

 28

 29

 30