Try this..
select EmpId+' '+convert(varchar(50),AttenDate,120)+CHAR(13)+status from dbo.Attendance
here CHAR(13)
for the New line and
convert(varchar(50),AttenDate,120)
120 for the Date Format to Convert AttenDate into YYYY-MM-dd format
think this'll help you.