Convert Date into Text

I

Irshad Alam

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
 
I

Irshad Alam

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
 
S

Sergey Poberezovskiy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Text to Number 2
Convert Word to Number 4
Creating a Search using a combo box and then creating a report. 4
Date Formats 4
VBA code to call first date of the year and last date of the year 2
Macros to convert Data into date format and then plot in graph 7
Convert Text to Date Month and Year 1
How to convert text file into excel using macro vba 2

Top