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

Dale E. Reed Jr. ( (no email) )
Wed, 26 Feb 1997 10:47:53 -0800 (PST)

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.