June 3, 2011 at 12:28 am
Hi,
I am getting string in format dd/mm/yyyy. In SSRS i want to convert it to Date format. Error is shown if using CDATE.
Note: If date is in mm/dd/yyyy format than SSRS is easily converting.
June 3, 2011 at 6:05 am
you can use the format ( dot net ) command in ssrs to make the date look like however you want.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
June 3, 2011 at 8:34 am
go to the textbox properties in the report,and choose the format and go tot the date and choose the dd/mm/yy fromat in the slection.
I hope that solve ur issue..
Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉
June 4, 2011 at 1:50 am
Actually my problem is that date is coming in dd/mm/yyyy string format from database now when i am trying to convert it to any date format in ssrs, it throws error saying this is not a date.
No error is shown when converting mm/dd/yyyy string to date.
It is happening only when date is in dd/mm/yyyy.
Final conclusion: ssrs is not recognizing dd/mm/yyyy string format as date
June 4, 2011 at 9:10 am
sunilg 95099 (6/4/2011)
Actually my problem is that date is coming in dd/mm/yyyy string format from database now when i am trying to convert it to any date format in ssrs, it throws error saying this is not a date.No error is shown when converting mm/dd/yyyy string to date.
It is happening only when date is in dd/mm/yyyy.
Final conclusion: ssrs is not recognizing dd/mm/yyyy string format as date
What is the SQL statement you are using to get this column from the database?
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
June 4, 2011 at 3:49 pm
Can not access database. it is coming in dd-mm-yyyy string format.
June 4, 2011 at 7:07 pm
sunilg 95099 (6/4/2011)
Can not access database. it is coming in dd-mm-yyyy string format.
What do you mean you cannot access the database? How are you getting the data in the report? It has to either be a select statement you have written for the dataset or a stored procedure.
Either way, the question still stands - what is the SQL statement being used to return that column?
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
April 13, 2016 at 4:40 am
Hi,
Did you find any resolution for this as i am facing the same issue.
June 16, 2020 at 4:44 pm
Split(Fields!Fecha_.Value,"/")(1)+"/"+Split(Fields!Fecha_.Value,"/")(0)+"/"+Split(Fields!Fecha_.Value,"/")(2)
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply