Convert Date into Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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 :-)
 
Back
Top