I am trying to create a SQL statement that will search within a field called description and find the DATE. Once the Date is found, it needs to be GROUP BY DATE & the field after Date (See below example 01/01/04-06/30/04 is Date & $0-19 E is the second data that needs to be GROUP BY). The issue is the DATE is not always in the same position, so I cannot use a substring field. Also, the Date data is typed by Customer Service Rep. and it is not always in the same format, meaning
the date 07/01/03 can be 7/1/03 or 7/01/03 or 07/1/03. Below is the data in the description field how it looks like.
CASUAL GIFT BYRS ONLY 01/01/04-06/30/04 $0-$19 E
CASUAL GIFT BYRS ONLY 01/01/04-06/30/04 $0-$19 R
CASUAL GIFT BYRS ONLY 7/01/03-12/31/03 $100+ R
CASUAL GIFT BYRS ONLY 7/01/03-12/31/03 $100+ E
CASUAL GIFT BYRS ONLY 1/01/03-06/30/03 $100+ R
CASUAL GIFT BYRS ONLY 1/01/03-06/30/03 $100+ E