Hi , I trying to create a sql query in code that queries a holiday table between two dates. the trouble is that the code seems to format the date in the us style meaning that for the 1st to the 6th of Jan I get everything up to the June. Can anyone help . the query results are below and . Any help appreciated. i tried using # but the same problem exists
SELECT [tbl ref Public Holidays].[Holiday Date], Weekday([Holiday Date]) AS Test
FROM [tbl ref Public Holidays]
WHERE ((([tbl ref Public Holidays].[Holiday Date]) Between "1/1/2005" And "6/1/2005"));
SELECT [tbl ref Public Holidays].[Holiday Date], Weekday([Holiday Date]) AS Test
FROM [tbl ref Public Holidays]
WHERE ((([tbl ref Public Holidays].[Holiday Date]) Between "1/1/2005" And "6/1/2005"));