SELECT targetDate, getdate() AS today, datediff("day",getdate(),targetdate) as daysRemaining FROM projectTable --snip--

On today #dateformat(test.today,"dd-mmm-yyyy")#
we have #test.daysremaining# days remaining
until #dateformat(test.targetdate,"dd-mmm-yyyy")