General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only