DateTime field shows Date and Time in Visual Studio, but only Date in Report Builder's Query Designer
Monday, January 28, 2013 7:28 PM
I have a Dimension with DateTime field which shows Date and Time when browsing the dimension in Visual Studio.
But when I execute the query in Query Builder, it only shows the Date in Report Builder (2009-06-06 00:00:00:000). I would prefer not to separate Date and Time into different fields, because I would eventually like to add Start and End Date and Time parameters (which is another thing I still need to conquer).
The source field in SQL Server is an actual DateTime field.
Wednesday, January 30, 2013 7:35 AM
Does the datetime filed show Date and Time in two fields in the report? I have test it on my environment, i cannot reportduce the issue. Maybe the issue was caused by the query. Do you use MDX in the query? Please provide more info, so that you can get more help.
- Marked As Answer by Dave60654 Thursday, January 31, 2013 8:42 PM
Thursday, January 31, 2013 8:42 PMSorry, user error. I was looking at old date fields that had no times specified, whereas the new ones had times. You helped by indicating that you were unable to duplicate the problem though. Thanks.
- Edited by Dave60654 Thursday, January 31, 2013 8:42 PM