var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Date function
Is it possible to retrive the number of days between two dates.
I'm aware of the DateDiff function but I can't figure out how to calculate the number days between two columns containing dates in a table.
All help is welcome
select datediff (dd,col1,col2) from your table
Get yourself a copy of the The Holy Book
order has no physical Brett in The meaning of a Kaiser . -database data
declare @fd1 datetime, @fd2 datetime
set @fd1 = '20040513'
set @fd2 = getdate()
select datediff(d, @fd1, @fd2)
It works perfect
Thanks alot both of you
Try to use BOL next time. Your example described in detail