Date Format

[sdel_nevo]

Hi All

sorry if this has been posted before, but here goes

i am trying to format a date field to show Friday 22nd of November



how can i get the correct statement to show behing the numbers?

so 01 becomes 1st
02 become 2nd
03 become 3rd

etc etc

many thanks

Steve

[lfpm062010]

I found this in another site. I hope this helps.

Format(Now(), "dddd d""" & IIf(Right(Day(Now()), 2) \ 10 = 1, "th", Nz(Choose(Right(Day(Now()), 1),"st","nd","rd"), "th")) & """ mmmm, yyyy hh:nn:ss")

[sdel_nevo]

Hi lfpm062010

Many Thanks

Steve