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
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
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
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
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