Date Format: how to output dates that are not US?

		Microsoft Office Forums > Microsoft Word > Word VBA
Date Format: how to output dates that are not US?

FAQ

Mark Forums Read

Thread Tools

Display Modes

10-28-2013, 03:30 AM

tinfanide

Windows 7 64bit Date Format: how to output dates that are not US?

Office 2010 32bit

Expert

Join Date: Aug 2011

Posts: 312

Date Format: how to output dates that are not US?

Code:

sDate = Format(DATE,"TIME \@ ""EEEE年O月A日 星期W""")

'' output:
'' EEEE年O月A日 星期W

I copied the field codes onto VBA but it does not work.
How can I output a date other than a US's one, like in this example, a Chinese one?

Any help would be appreciated.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Default dates for a Date Picker	BoringDavid	Word VBA	2	09-11-2013 01:42 AM
How to change number format of dates	ketanco	Project	1	09-11-2012 02:34 PM
date format	gsrikanth	Excel	1	12-28-2011 05:06 AM
MS Project Start Dates not matching the Status Date	sjodom	Project	3	12-04-2011 08:45 AM
Automatic Date Function Corrupting Printer Output	Theodulf	Word	0	05-28-2010 12:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:42 AM.