If I understand your question correctly, you need to add a condition to fetch only thoughts starting from current date and change the sorting. Something like
SELECT ThoughtId,
CompanyCode,
CompanyId,
Thought,
convert(varchar(6),ThoughtDate,106) ThoughtDate,
case
when isnull(IsActive,0)=0 then 'InActive'
else 'Active'
end as Status,
CreatedBy,
CreatedDate,
ModifyBy,
ModifyDate
FROM ThoughtofTheDay
WHERE CompanyId=214
AND ThoughtDate >= GETDATE()
ORDER BY ThoughDate ASC