How to control format of datetime attributes?

There is an attribute that have type DateTime, based on the field type in data source. It hasn't separate name column. The member caption is formatted as yyyy-MM-dd hh:mm:ss. Can I control the format of Member name without giving separate name column.

I assigned different format in the format field of key property window, but it had no effect. What I did wrong?

Hello. I do not think that you will have to pay any penalty from adding a new column in the data source view with a new format of your date column. I recommend to use the TSQL function CONVERT that have arguments for different date formats. Have a look at CONVERT in Books On Line, and you will see the complete list of different codes/arguments for different date formats.

HTH

Thomas Ivarsson

|||

Thank you,

I thought about more sofisticated solution, that can be used in multi culture environment without adding x additional fields with "formatting" of a datetime attribute.

I hoped, that the AS2005 is smarter as AS2005 and offers more possibilties.

Do you know what is the format field in key properties for?

how to connect domain SQLSERVER2005 to WORKGROUP SQLSERVER2005

hi

COMPUTER-1

IP ::::: 129.100.100.5

COMPUTER NAME IS ::::: HASH

MEMBER OF DOMAIN

in this computer sqlserver express edition is installed, i want to remove this express becoz in configuration manager it show two SQLSERVER'S are running. when i browse from COMPUTER - 2 for network servers it show server name as HASH/SQLEXPRESS, but not the main SQLSERVER.

COMPUTER -2

IP::::129.100.100.142

COMPUTER NAME::: FEROZ

MEMBER OF WORKGROUP

can anyone help me how to connect these two computers and remove this express edition

iam new to sqlserver configuration

thanks in advance

waiting for eager reply

To remove Express Edition, go to Control Panel/Add & Remove Programs/SQL Server 2005 - Change, and it will show you what is currently installed, and you will be able to chose to remove your Express instance.

As for how to 'connect these two computers', do you mean for database mirroring? It isn't clear from your post, and this is a database mirroring forum.