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