CODEWITHSUNDEEP
reporting-services
user2300035
user2300035

Reputation: 53

SSRS datepart expression, Error

I didnt know whats wrong with this expression.This expression always return #error.how to solve this?

=MonthName(datepart("M",format(Fields!date.Value,"yyyy-MM-dd"))) + " " + datepart("yyyy",format(Fields!date.Value,"yyyy-MM-dd"))

expression works fine with just=MonthName(datepart("M",format(Fields!date.Value,"yyyy-MM-dd"))), when added + " " + datepart("yyyy",format(Fields!date.Value,"yyyy-MM-dd")) become error.curious.

Upvotes: 1

Views: 10761

Answers (2)

gannaway
gannaway

Reputation: 1882

Use & instead of + to concatenate strings in SSRS expressions - Operators in Expressions (Report Builder and SSRS)

=MonthName(datepart("M",format(Fields!date.Value,"yyyy-MM-dd"))) & " " & datepart("yyyy",format(Fields!date.Value,"yyyy-MM-dd"))

Upvotes: 2

robnick
robnick

Reputation: 1768

Try ===>

=MonthName(datepart("m",format(Fields!date.Value,"yyyy-MM-dd"))) + " " + datepart("y",format(Fields!date.Value,"yyyy-MM-dd"))

Upvotes: 0

Related Questions