select count(*) from [FRU_PROJECT_DEMAND] where Convert(varchar(10),PRO_MISSION_NO,120) = Convert(varchar(10),getdate(),120)
