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]MS Sql Server LazyDBA home page