sql server reporting services: Format a number to be a date format -- sql server reporting services

You're in the

sql server reporting services

group:

Format a number to be a date format

Jeanne Conde
12/27/2005 12:44:09 PM

sql server reporting services:

I have a number field that looks like this:
8 characters long yyyymmdd
ie: 20051201

I can not change its type to a date field. In Access and Crystal I was able
to manipulate the number to make it look like a date ie: 12/01/2005

Can anyone help me figure out how to format the field like this?

thanks so much
--

Re: Format a number to be a date format

Techotsav
12/27/2005 9:57:47 PM

Well, i guess it can be achieved by code snipet, pass value as argument
in code block and through VB syntax manipulate string in ne form.

Hope it helps

Re: Format a number to be a date format

Potter
12/28/2005 6:32:05 AM

The VB.NET function Data.Parse will be the way to go.

RE: Format a number to be a date format

MACNR
12/28/2005 6:54:34 AM

Right click the field, click on properties.

In the 'format' section, choose cuistom and enter dd/mm/yyyy

That should do the trick

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn