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 '1' and Year(Assn_Finish_Date) like '2009'

    Web Based PMS Events Calendar
Date of Events in this Month are
 
<< January 2009 >>
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

 31