Hello all, I have an ODBC Excel data source for an SSRS 2005 report. I need to convert a datetime into date. CONVERT doesn't work. I get an [ODBC Excel Driver] undefined funciton CONVERT. I've tried several iterations of CDate as an expression in the textbox property, including: =CDate(Fields!Estimated_Receipt_Date.Value) Can someone please tell me what I'm missing? Thanks, Jeff

Hi, Since the dataset contains a datetime field, in order to display only date part, one approach is to specify the Format property of the textbox. For example, we can select the textbox which used to display the datatime field, and then specify the Format property to MM/dd/yyyy. After that, only date will be displayed. For more information about Standard Date and Time Format Strings, please refer to: http://msdn.microsoft.com/en-us/library/az4se3k1.aspx If you have any question, please feel free to ask. Thanks, Tony Chain Tony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Perfect. Thank you, Tony.