GETDATE() problemer?

more than likley becaus egetdate() will also include the time. And if your dato field only has the date then it WILL be less than getdate

egetdate() = getdate()

Yes Terry, your right, my dato field only contain the date 3/13/2004 - can I do it in another way so I get 3/13/2004 included???

Prøv

SELECT * FROM vagtplan WHERE dato >= floor(GETDATE())

Funktionen floor behandler datoen som en float og fjerner decimaler. Ellers lav en CONVERT() mod getdate() til et format der kun indeholder datoen og ikke tidspunktet. Du kan se detaljer for convert i Books Online.

Har fået denne til at spille:
SELECT ID, ugedag, tidsrum, klar, Convert(char(10),dato,103) AS dato FROM vagtplan WHERE dato >= CONVERT(CHAR(10),GETDATE(),110)

Ved I noget om 103 og 110?

alpapa

103 = British/French
110 = USA

what do you mean "ved I noget ...."?

I just meant that if you knew what those numbers where it would be nice to know ;-)

OK! If you look in Books Online there is a complete list.

Look where? Do you have a URL?

Books Online! (SQL Server Help). Its included with MS SQL Server, or dont you have that?
If you dont Ithink you can download a trail version of SQL Server and you get it that way. When the trial has expired you still have Books Online

Okay - I will try that, thanx ;-)

Du kan blot downloade Books Online direkte fra www.microsoft.com/sql - du behøver ikke at tage en trial version ned af mssql.