Andy Williams
Andy Williams

Reputation: 907

SSRS Report Formatting Date time

How do I write the vb expression for "mm/yy" of a datetime?

I've tried this with no success

=Fields!myValue.Value & Format(Fields!myDateTime.Value,"MM/yy")

Upvotes: 0

Views: 85

Answers (1)

Alan Schofield
Alan Schofield

Reputation: 21748

It's not clear what your datatypes are. Assuming myValue is numeric abd myDateTime is a DateTime type then you will probably need to convert the numeric value to a string.

Something like.

=CStr(Fields!myValue.Value) & Format(Fields!myDateTime.Value,"MM/yy")

If this does not help, post some sample data, including the datatypes and expected result

Upvotes: 1

Related Questions