Set int count from datediff(day)

[Sl1ver]

i got an int @count
i want to set it to the number of day differences in sql, i tried

@count = datediff(day,min(date),max(date))
 

even tried to cast datediff to int but it doesn't work, any suggestions?

[NeoPa]

The first parameter should be a short string. What you have is not valid. I expect 'd' would do it for you, but see DATEDIFF (Transact-SQL) for the full story.