Check the Regionnal Settings for the account used to run the job; you may
well need to change these to align with your own.

> -----Original Message-----
> From: Colin Shelton [SMTP:Colin.[Email Address Removed] Sent: Monday, May 27, 2002 10:20 AM
> To: Mssqldba (E-mail)
> Subject: Problem with a scheduled DTS job.
>
> I am running a DTS job using the scheduler and it is bringing back dates
> in
> the format M/D/YYYY. When I run the job manually on the server I get
> dates
> in the format DD/MM/YYYY as I require. Where is it picking the M/D/YYYY
> format up from & how can I change it?
>
> Colin Shelton.
> IT Services,
> UCE, Perry Barr, Birmingham, B42 2SU.
> Tel: 0121 331 5665
> Email: colin.[Email Address Removed]
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page