Date + st, nd, rd, th

[VincentO'B]

Can anyone suggest a way through my brick wall.

I am trying to append the above abbreviations to a date so far I have: If (Day ( IssueDate ) = 1 or 21 or 31; "st" ;"" )

If the date is 23rd the result is 23st which not what I expected, I have tried everything I can think of maybe I am missing something obvious.

[comment]

See:

http://fmforums.com/forum/showtopic.php?tid/168355/

[VincentO'B]

Thank you for pointing me in the right direction Comment. That worked a treat.

I used.......Case( not IsEmpty(date),

DayName(date) & ", " & MonthName(date) & " " & Day(date) &

Case(

PatternCount( " 1 21 31 ", " " & Day(date) & " " ), "st",

PatternCount( " 2 22 ", " " & Day(date) & " "), "nd",

PatternCount( " 3 23 ", " " & Day(date) & " " ), "rd",

"th" ) )

A big thanks to -Queue- for the code.

Vinny