VB.Net or SSRS code for Ordinal Numbers
28-Jan-1212 Leave a comment
Easily found on web. See example in SRS.ReportingServices.Functions and also in my invoice report.
With acknowledgement to:
http://www.jigsawboys.com/2010/03/04/ordinal-number-in-reporting-services/
Public Function FormatOrdinal(day as Integer) As String
SELECT CASE (day Mod 100)
CASE 11,12
CASE 13
Return day.ToString() + “th”
END SELECT
SELECT CASE day Mod 10
Case 1
Return day.ToString() + “st”
Case 2
Return day.ToString() + “nd”
Case 3
Return day.ToString() + “rd”
Case Else
Return day.ToString() + “th”
END SELECT
End Function
Good luck!