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 2005 Forums
 Analysis Server and Reporting Services (2005)
 Date conversion

Author  Topic 

stevengagnon
Starting Member

3 Posts

Posted - 2008-02-06 : 22:39:27
I have a SQL database where the dates appear in the format "733433".
If you convert in the "Select" statement, it's fine. You can use the day, month, year concatenated in an excel expression, converts fine. As an expression in reporting services, I receive an error. An help is appreciated.

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2008-02-06 : 22:56:55
>>If you convert in the "Select" statement, it's fine.
post that statement please.

What is the datatype of the column?

Be One with the Optimizer
TG
Go to Top of Page
   

- Advertisement -