Forums
This topic is locked
short date setting
Posted 19 Jun 2002 16:31:34
1
has voted
19 Jun 2002 16:31:34 Shirley Van Vleck posted:
I am using Access XP and a Windows 2000 server. I have defined my date in Access as a short date, made a recordset in UD then tested my data. I get a return of this date format Sun Jun 15 00:00:00 CDT 2002. I have checked the Regional Options on my server and my machine, they are set to short date m/d/yyyy. I have also upsized to SQL with the same results.At home I am using Access 2000 and Windows 98. The date works fine.
Any help would most appreciated.
Replies
Replied 20 Jun 2002 03:10:52
20 Jun 2002 03:10:52 b w replied:
When you are in the bindings part there is a bindings and format to the right side. Click on the format and click on short date or something like that.