Clever Geek Handbook

SSRS expression to remove leading 0 in date

My report shows the date time as "Friday, May 08, 2015", but I would like to remove the 0 in the date field if the value is one digit.

enter image description here

Should I use an expression to handle this? And if so, can I get some help with expression?

Thank,

+3


source to share


2 answers


Yes, use an expression, the expression will look like this (replace Now()

with your date value)



=Format(Now(), "dddd, MMM d, yyyy")

+2


source


Your best bet is to use this expression:

=Format(Now(), "dddd, MMM d, yyyy")


from

  • dddd

    day of week
  • MMM

    month
  • d

    day of month
  • yyyy

    4-digit year
+2


source






More articles:


All Articles