Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting a field.
Message
 
 
To
27/07/2001 15:09:24
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00536043
Message ID:
00536636
Views:
8
It actually returns a date value. The format for the display of Date expressions is controlled by SET DATE TO command that has default setting of AMERICAN (MM/DD/YYYY). If you want to have DD/MM/YYYY format for whole application than use SET DATE TO DMY. See SET DATE TO topic in the help for details.
IF you want just have the date shown in DD/MM/YYYY format only in that place than you'll have to convert your numeric date to the character string
RIGHT(STR(lnDate,8),2) + "/" + ;
	SUBSTR(STR(lnDate,8),5,2) + "/" + ;
	LEFT(STR(lnDate,8),4)
>Thank for your reply.
>I tested it but this return the field with the format MM/DD/YYYY and the format that I'm looking for is DD/MM/YYYY.
>What I hace to change in the runtime.?
>
>TIA
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform