Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Date Time Values
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00129962
Message ID:
00130382
Views:
31
>Mark,
>
>Most people create some kind of class that displays the date but puts a datetime in the corresponding field. There was a thread about this several months ago. You might want to search for it here and on dejanews (it might have been in one of the news groups).
>
>>I have a date/time field in my SQL Server database. When I create a remote view in my fox database, it comes through as a date/time also. Not a problem, you may think!
>>
>>Unfortunately the users do not wish to see the time portion of the field.
>>
>>Is there any way of getting fox to ignore or hide the time portion of the date/time field without any extensive recoding? Any advice would be greatly appreciated.

Open the view, select the field, click properties button and change the DATA TYPE to date.
System Analyst
Nabil B. Ghrayyeb
nabilg@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform