Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date format problem in grid
Message
From
08/06/2012 02:15:47
 
 
To
08/06/2012 00:59:18
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
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:
01545638
Views:
42
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform