Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 convert datetime

Author  Topic 

u2envy1
Yak Posting Veteran

77 Posts

Posted - 2007-09-19 : 05:07:58
I have a select query with a field data type of smalldatetime.
I would like to change the format in reporting services on my report. I have the following but it give wierd figures.
=Format(Fields!InceptionDate.Value, "d,MMMM, yyyy hh:mm tt")
Im getting this figures. 29, AuA.D.u0p, 2007 01:53

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-09-19 : 05:18:33
Duplicate: [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89610[/url]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page
   

- Advertisement -