This is driving me nuts. I have to retrieve records by date range from a SQL Server database that is someone's legacy data off load. The dates are stored as text fields. I'm having trouble with the Wher clause. What syntax would I use to do this simple retrieval?
Where [Customer_Po] = '1000' and [co#] = '1' and [Invoice_Date] >= '01/01/1996' and [Invoice_Date] <= '12/31/1996'"
The above returns erratic data, probably because 1/1/2000 is less than 12/31/1996 when computing strings.
Thanks in advance for your help!
Where [Customer_Po] = '1000' and [co#] = '1' and [Invoice_Date] >= '01/01/1996' and [Invoice_Date] <= '12/31/1996'"
The above returns erratic data, probably because 1/1/2000 is less than 12/31/1996 when computing strings.
Thanks in advance for your help!