var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: datediff (today - date)
I want to return the number of days between a date in the database and today
I must return
user.lName & " (" & (datediff(now - user.lastVisit)) & " )"
John Turner (38)
where 38 are the days between last visit and now
see this,now I think you can do it easily
declare @datevar datetime
select @datevar = getdate()
*Example for datediff : getting no of days passed since 01-01-2006*/
select datediff(dd,'20060101',@datevar) [No of days since 01-01-2006]
Success is the ability to go from one failure to another with no loss of enthusiasm.
- Sir Winston Churchill