Hi Guys,

I run the following query:

DECLARE @Today DATETIME; SET @Today =GETDATE()
SELECT Case.CustomerName, Case.CreatedOn
FROM MSCRM.dbo.Case Case
WHERE Case.CreatedOn BETWEEN @StartDate AND @Today
ORDER BY Case.CreatedOn


It gives the out put:
03/22/2011 8:12:17 AM Microsoft Corporation (US Date & Time)

Can anyone show me how i should ammend my code above so the output is like this:
22/03/2011 Microsoft Corporation (UK Date)

Thanks Guys,
M