benjee Personal Jesus Local time Today, 12:26 Joined Mar 19, 2003 Messages 53 Apr 17, 2003 #1 Good evening, writing a query, and i need to retrieve all dates before 12-04-03 for example. How do i do this?
Good evening, writing a query, and i need to retrieve all dates before 12-04-03 for example. How do i do this?
R raskew AWF VIP Local time Today, 06:26 Joined Jun 2, 2001 Messages 2,734 Apr 18, 2003 #2 In the query-grid, use this as criteria: <#4/12/03# [This is US Short-Date format representing 12-Apr-03. You will probably have to adjust for regional settings.]
In the query-grid, use this as criteria: <#4/12/03# [This is US Short-Date format representing 12-Apr-03. You will probably have to adjust for regional settings.]