Re: Urgent help for Emerald newbie: Trying to add MBR

Mauricio Marquez ( mmarquez@mail.eic.com.mx )
Wed, 26 Feb 1997 16:40:04 -0600

At 10:47 AM 26/02/97 -0800, you wrote:
>On Wed, 26 Feb 1997, Mauricio Marquez wrote:
>>
>> '','Monterrey', '26/02/97','26/02/97', '12/03/97',0, 1,'Anual', '
>> Invoice','', '26/02/97','26/02/97', '','', '','', '',0, '','26/02/97 2:26:07
>> AM', 'sa',0, 0, 0, 1)
>>
>> I read in the mailing list that the date format could be wrong, but I've
>> tried every possible format and it still doesn't work.
>
>Its NOT the date you are entering, its the date format your
>machine has selected in their Control Panel, Regional
>settins. Yours is set for dd/mm/yy and your SQL Server's is
>set for mm/dd/yy. Therefore its seeing 26/02/97, and 26 is a bad
>month. Emerald will convert whatever you enter to the
>date format of your Regional Settings, before sending it
>to SQL Server.
>
>Dale

Thank you, that worked.

Mauricio
Enlace Internacional de Comunicaciones
Internet Services and Consulting
Phone: 528.346.4667 FAX: 528.345.6987
http://www.eic.com.mx e-mail:mmarquez@mail.eic.com.mx