Converting Date in Words

[sanbhau]

I want to derive a field containing the dates in another field written as words in access query. Eg. Field1 contains date of birth such as 18-May-1989, i want to get 'Eighteenth May, Nineteen hundred Eighty Nine in Field2 in corresponding record. Is it possible?


Is it possible? Pl. guide me in simple terms concerning my lower skill level.

[orange]

I found this via google. I have tested it.
http://www.pcreview.co.uk/threads/co...words.3841289/

Sub testdateWord()

Dim d As Date: d = #3/7/1943#
Debug.Print DateToWords(d)
End Sub

Result:

Seventh of March One Thousand Nine Hundred Forty-Three

[sanbhau]

thanks for helping. my problems have been sorted out.