Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting Long Date in English
Message
 
 
To
19/08/2003 14:59:00
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00821522
Message ID:
00821611
Views:
15
Tim,

You can create your own UDF that would format date any way you want. For example
FUNCTION DateToEnglish(tdDate)
RETURN IIF(EMPTY(tdDate), "", ;
	STR(DAY(tdDate),2) + " " + ;
			GETWORDNUM("January,February,March,April,May,June," + ;
				"July,August,September,October,November,December", ;
    MONTH(tdDate), ",") + ;
		STR(YEAR(tdDate),5)	)
>In a report date field you can set the format to @YL to get like “18 August 2003”. But this is sensetive to the format set in Control Panel->Regional Settings. Meaning if Swedish you get “den 18 augusti 2003”. Is there a way to get the long English format without changing the general setting
>on every computer?
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform