How can I type the following query in a query builder when I am editing and configuring a data set from the edit designer using C# and SQL Server, so I can specify the Date format, to pick only the date from a column that has both date and time taken from
WHERE (ColumnName BETWEEN @dateFrom AND @DateTo)
Now I need to specify the format of the dates as only date without the time. In the query builder in the edit designer of a data set does not accept the code with the format:
WHERE (ColumnName BETWEEN @dateFrom .('MM/dd/yyyy') AND @DateTo.('MM/dd/yyyy'))
How can I fix this and specify the format to take only the date when writing the query in a query builder when configuring a DataSet????
View Complete Post