Search code examples
datetimessrs-2008ssrs-expression

SSRS Expression To Remove Leading 0 In Date


My report displays the date time as "Friday, May 08, 2015" but I'd like to remove the 0 in the date field if the value is a single digit.

enter image description here

Should I use an expression to handle this? And if so, could I get some help on the expression?

Thanks,


Solution

  • Yes, use an expression, the expression will look like this (replace Now() with your date value)

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