SSRS Expression To Remove Leading 0 In Date

Question

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,

score 2 · Accepted Answer · answered May 22 '15 at 13:04

2

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

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

answered May 22 '15 at 13:04

paul

score 2 · Answer 2 · answered May 22 '15 at 13:08

2

It is best practice to use this expression:

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

with

answered May 22 '15 at 13:08

william.eyidi

2 Answers2