Greetings...I have a little problem here. I have a database field that holds a date formatted as such: mm/dd/yyyy. The database field is type VARCHAR not DATE...I originally did this due to formatting purposes however now its bitting me back. I'm running the following query:
SELECT DISTINCT ID,Date_Requested,advertiser_name,Station,terms,credit_approve,assigned_date,assigned_no FROM Results WHERE Date_Requested BETWEEN '12/15/2005' AND '01/04/2006'
It doesn't seem to recognize them as dates, which only makes sense because they are VARCHAR data types.
My question is there an easy why either to convert the field type from VARCHAR to DATE while preserving the data OR can I create a function that somehow recognizes the strings as type DATE?