How to

  • Thread starter Thread starter Mat
  • Start date Start date
M

Mat

How to get month or day from date as string.?
the string will depend on language settings

mydate.Month returns number but i want the string representing this number
like JANUARY, DECEMBER..or in french JANVIER....or in croatia... whatever
 
* "Mat said:
How to get month or day from date as string.?
the string will depend on language settings

mydate.Month returns number but i want the string representing this number
like JANUARY, DECEMBER..or in french JANVIER....or in croatia... whatever
Click to expand...

Convert it to a 'DateTime' first using
'DateTime.Parse'/'DateTime.ParseExact'. Then get the month from the
'DateTime'.
 
Mat said:
How to get month or day from date as string.?
the string will depend on language settings

mydate.Month returns number but i want the string representing this
number
like JANUARY, DECEMBER..or in french JANVIER....or in croatia...
whatever
Click to expand...

Untested:

system.threading.thread.currentthread.currentuiculture.Datetimeformat.monthn
ames(mydate.month - 1)
 
You must log in or register to reply here.

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

Excel Vba to change displayed year automatically. 14
Mapping strings to integers 5
regular expressions for various date/time strings 3
#Name? error - Question on Dates 6
Using the Excel TEXT function within a VBA program 1
Integers behaving like strings 4
Saveas VBA question 1
Extracting numbers from a string 10

Back
Top