Format date for Certificates

[fdnyfish]

I have a training database that I want to automate Completion Certificates from.

I'm stuck on formatting the date of issuance of the certificate.

example.....

The date the course was completed was 12/01/10 , and is in a field called [completed_date] in my table.

I want to display that date on the certificate in the following format....



Issued this 1st day of December, 2010

Keeping in mind that depending on the day I might need to use (st, nd, rd, th).

Thanks for any help

[Rixxe]

Hope this helps:

http://www.techonthenet.com/access/f...ate/format.php

Not sure about adding rd,th,st etc

Good luck

[weekend00]

the easyest way is create a loopup table:
dayTable:
dayNum dayName
1 1st
2 2nd
3 3rd
4 4th
...
21 21st
22 22nd
23 23rd
...
31 31st

then put follow formula as datasource of the textbox:
="Issued this " & dlookup("dayname","taytable","dayNum=" & day(complete_date) ) & " day of " & format(complete_date,"mmmm, yyyy")