<div>
The underlying type is always a DateTime datatype. &nbsp;Just use<br />
=Format(Fields!yourDate.Va<wbr />lue, &quot;MM/dd/yyyy&quot;)<br />
or something like that for the display format when displayed
</div>


The underlying type is always a DateTime datatype.  Just use
=Format(Fields!yourDate.Value, "MM/dd/yyyy")
or something like that for the display format when displayed

<div>
I tried that before on the proc in the WHERE &nbsp;(A.Date &gt;=Format(@startdate, &quot;MM/dd/yyyy&quot;)) &nbsp;and I get Format is not a built-in function. 
</div>


I tried that before on the proc in the WHERE  (A.Date >=Format(@startdate, "MM/dd/yyyy"))  and I get Format is not a built-in function.

<div>
yeah, Format is not SQL it is a Reporting Services function.<br />
If it is in SQL that you want just the date try,<br />
SELECT CONVERT(VARCHAR,yourDate,1<wbr />01)
</div>


yeah, Format is not SQL it is a Reporting Services function.
If it is in SQL that you want just the date try,
SELECT CONVERT(VARCHAR,yourDate,101)

<div>
I also tried WHERE &nbsp;(A.Date &gt;=convert(varchar,@startda<wbr />te,101)) to no avail. &nbsp;The date field had to be a varchar on the table.
</div>


I also tried WHERE  (A.Date >=convert(varchar,@startdate,101)) to no avail.  The date field had to be a varchar on the table.

<div>
LOL we posted at the same time. 
</div>


<div>
It worked fine once I declared @startdate as a datetime. &nbsp;Thank you for the help. &nbsp;It seems so simple sometimes once you find out what the solution is. &nbsp;I have a lot to learn.
</div>


It worked fine once I declared @startdate as a datetime.  Thank you for the help.  It seems so simple sometimes once you find out what the solution is.  I have a lot to learn.

<div>
Glad to help. &nbsp;Good luck with your continued learning.
</div>


Glad to help.  Good luck with your continued learning.

<div>
<div class="content wysiwyg-content">
When using the date time picker to fill a parameter in a report is there a way to format the output so it only returns mm/dd/yyyy (ex. 04/01/2009) instead of returning the Date and Time?
</div>
</div>


When using the date time picker to fill a parameter in a report is there a way to format the output so it only returns mm/dd/yyyy (ex. 04/01/2009) instead of returning the Date and Time?

Format DateTime Picker

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.