SQL statement date filter

navifreak

Hi, i would like to know the syntax when filtering on a navision date field in a SQL statement.

e.g. posting_date > today

Thanks

Steven

PaddyMullaney

where Posting_Date > GetDate()

navifreak

Thanks for the quick reply... but I found the syntax I was looking for!


SELECT Sales_Header.Document_Type, Sales_Header.No_

FROM Sales_Header Sales_Header

WHERE (Sales_Header.Posting_Date={d '2004-08-26'})


steven