uk sql date

[Lapchien]

My query:

SELECT DateValue([Date/time call received]) AS [Date], TimeValue([Date/time
call received]) AS [Time], [T-cards].[Call type], [T-cards].[Sales outcome],
[T-cards].Postcode, [T-cards].[Customer name/contact]
FROM [T-cards]
WHERE (((DateValue([Date/time call received])) Between [Start Date] And [End
Date]) AND ((TimeValue([Date/time call received]))>TimeValue("08:00") Or
(TimeValue([Date/time call received]))<TimeValue("17:00")) AND
(([T-cards].[Call type])="Job") AND (([T-cards].[Sales outcome])="Booked"))
ORDER BY DateValue([Date/time call received]);
is hoping to return dates in uk format (entries between 8am and 5 pm), but
only works if you input the us date format mm/dd/yy. Can anyone help with
the uk date format..?

Thanks,
Lap

[John Bell]

Hi

Date formats can be effected by several things, including the language
settings, use of SET DATEFORMAT etc. You may want to check out sp_configure,
SET etc in books online.

If you want to specify a specific date/time format in an SQL statement check
out the CONVERT function

John
"Lapchien" <cc****@nospamplease.eclipse.co.uk> wrote in message
news:10***************@ananke.eclipse.net.uk...

My query:

SELECT DateValue([Date/time call received]) AS [Date], TimeValue([Date/time call received]) AS [Time], [T-cards].[Call type], [T-cards].[Sales outcome], [T-cards].Postcode, [T-cards].[Customer name/contact]
FROM [T-cards]
WHERE (((DateValue([Date/time call received])) Between [Start Date] And [End Date]) AND ((TimeValue([Date/time call received]))>TimeValue("08:00") Or
(TimeValue([Date/time call received]))<TimeValue("17:00")) AND
(([T-cards].[Call type])="Job") AND (([T-cards].[Sales outcome])="Booked")) ORDER BY DateValue([Date/time call received]);
is hoping to return dates in uk format (entries between 8am and 5 pm), but
only works if you input the us date format mm/dd/yy. Can anyone help with
the uk date format..?

Thanks,
Lap