Forum Discussion
Solved
Format Zip Code as Zip plus four if 9 digits - Paginated Report
Good Day,
I'm trying to create an expression to display a Zip Code as #####-#### if it is 9 digits or as ##### if it is 5 digits.
Can anyone point me in the right direction?
Figured it out:
=IIf(Len(Fields!Zip.Value) = 5, Fields!Zip.Value, Left(Fields!Zip.Value, 5) &"-" & Right(Fields!Zip.Value, 4))
1 Reply
Figured it out:
=IIf(Len(Fields!Zip.Value) = 5, Fields!Zip.Value, Left(Fields!Zip.Value, 5) &"-" & Right(Fields!Zip.Value, 4))