SQL query med dato....
Så nu rabler det for mig....Er der ikke en venlig sjæl, der kan rette denne query for mig....
SELECT Content, Created FROM News, Languages, Stations WHERE News.Expires > '"+ DateTime.Now +"' AND News.Activation < '"+ DateTime.Now +"' AND News.LanguageIndeks = Languages.Indeks AND Languages.Code = 'DK' AND News.StationIndeks = Stations.Indeks AND Stations.Number = '66' AND News.Status = '1'"
Jeg får denne fejl....
Exception Details: System.Data.SqlClient.SqlException: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
ASP.NET / C#
Win2K Srv.
MS SQL 2000 Std. Edt.
På forhånd tak!
