<query> <orderby> <fieldref name="ID" /> </orderby> </query> <viewfields> <fieldref name="JobNumber" /> <fieldref name="JobName" /> <fieldref name="JobDescription" /> <fieldref name="StartDate" /> <fieldref name="EndDate" /> <fieldref name="JobStatus" /> <fieldref name="Comments" /> </viewfields>
select cast(GETDATE() as DATE) as date_only from Table
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)