Thursday, March 8, 2012

Date format in ssrs

i just want to get a date format like this 'dd-mmm-yyyy'

Hello Joshy,

You can do this a couple of ways...

1. Right-click on your textbox with the date in it, and go to Properties. In the Format tab, enter this as your format code: dd-MMM-yyyy

2. Enter this as the expression for your textbox which holds the date: =Format(Fields!DateField.Value, "dd-MMM-yyyy")

Either way, today's date would show like this: 28-Mar-2007

Hope this helps.

Jarret

No comments:

Post a Comment