Convert Date into Text

[Guest]

I want to convert the date into text.

For example : MydateField is : 23-07-2007
It want it to be converted into a text field as :
Twenty Third of July Year Two Thousand Seven

Please advice a VB Code for this.

Regards.

Irshad

 

[Guest]

http://vb-helper.com/howto_number_to_words.html

 

[Guest]

Thanks for your reply.

As I am new in the VBA code. I could not get what to do. As the code at the
link is totally related to currency. How to sort out.

Please advise.

Regards.

Irshad

 

[Guest]

I just searched in Google for "VB number to word" and this one seemed more
relevant - there is no built in function - you will need to code it yourself.

The example just deals with pure numbers - you will need to expand it to
suit your needs. One thing to help you on your task:
Format(dateVariable, "mmmm") function returns the name of the month for
dateVariable - and you have an example of how to deal with numbers in the
link.

A bit of fun - and you have your very own function