Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date format problem in grid
Message
From
08/06/2012 13:32:39
 
 
To
08/06/2012 02:15:47
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01545635
Message ID:
01545691
Views:
33
>>Hi,
>>
>>I have a grid in a Form, the grid have 1 col. is date field.
>>the Format property of the date is 'D', I set the date to british (dd/mm/yyyy)
>>When the grid display the records, the date is in dd/mm/yyyy format,
>>but when I click the record the date change to mm/dd/yy format.
>>
>>Why ?
>>
>>Please help me to fix it.
>>
>>Thanks.
>>Derek
>
>Have you tried putting the following statements in the main program file:
>
>SET DATE BRITISH
>SET CENTURY ON
>
>that way from that point onward the date format will be specified as dd/mm/yyyy

Might need to SET SYSFORMATS OFF to be sure you are getting the Century and Date formats you want.
Previous
Reply
Map
View

Click here to load this message in the networking platform