Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Converting a field.
Message
 
 
À
27/07/2001 15:09:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00536043
Message ID:
00536636
Vues:
7
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform