M marks2007 Registered User. Local time Today, 11:17 Joined Nov 12, 2007 Messages 31 Dec 14, 2007 #1 Hi, I try this way but it doesn't work SELCT * FROM TABLES WHERE ApplDt > 2007-10-01 which format I have to use.Thanks Mark
Hi, I try this way but it doesn't work SELCT * FROM TABLES WHERE ApplDt > 2007-10-01 which format I have to use.Thanks Mark
boblarson Smeghead Local time Today, 11:17 Joined Jan 12, 2001 Messages 32,059 Dec 14, 2007 #2 US date format, plus with date delimiters: SELECT * FROM TABLES WHERE ApplDt > #10/01/2007#
