i move to SQL SERVER from Microsoft Access
when i search a record i need to do
mm/dd/yyyy
and when i insert a new record it do
mm/dd/yyyy
my data is dd/mm/yyyy
in Microsoft Access i dont have this problem
HELP

It doesn't metter much in what format date is recorded in DB. You can, and should, always format date directly on page in the way you want. Do that by setting Locale ID or formating with some ASP function.


<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
i move to SQL SERVER from Microsoft Access
when i search a record i need to do
mm/dd/yyyy
and when i insert a new record it do
mm/dd/yyyy
my data is dd/mm/yyyy
in Microsoft Access i dont have this problem
HELP



<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager

Edited by - vfarcic on 26 Mar 2002 09:14:43