select
	ID,
	project_ID,
	title,
	details,
	DATEPART(dd, date_expected),
	DATEPART(mm, date_expected),
	DATEPART(yyyy, date_expected),
	DATEPART(dd, date_completed),
	DATEPART(mm, date_completed),
	DATEPART(yyyy,date_completed),
	is_complete = case 
		when date_completed is null then 0
		else 1
	end
from
	MILESTONES
where
	ID = 1