I want to display 24 hours time and date in SSRS & for that I am using Format(now,"MM/dd/yyyy HH:mm:ss") but I am using this expression in Parameter, where I need to define datatype of that parameter as DateTime, not string. For Expression Format(now,"MM/dd/yyyy
HH:mm:ss"), If I use DateTime datatype, It is showing error but working with String datatype.
I have parameter To Date and value of this parameter should be 10/11/2010 13:09:16 (To Date: 10/11/2010 23:09:16) , not in AP or PM format and datatype of this parameter, want to keep DateTime that I can select value from Calender.
Please suggest me how I can achieve this?. I don't want to do it in stored Procedure side, want to do it in report side.
View Complete Post