Date Format

[macrogeek]

Hi all, this is my first post

Please can anyone tell me how to format a date so that the following is displayed

Wednesday 21st November 2005

I can use dddd dd mmmm yyyy but it does not give the st. I would like it to show th / rd / st /nd etc.

Any ideas greatly received.

 

[babycody]

Try this tut on ozgrid http://www.ozgrid.com/News/DateFunctionProperFindNth.htm

 

[macrogeek]

Its works

Hi cheers it work.