How to Retrieve Records of 2 Dates Stored in MySQL Text Type?

[Snatcher]

Hello friends; I have a date data saved in the TEXT format with the date 26.07.2019. I want to retrieve the data up to 1 week before this date. $convert7 = strtotime('-7 day',strtotime($date)); $new7date = date("d.m.Y",$convert7); I obtained the date from 7 days ago in this way. "SELECT * FROM orders WHERE order_date BETWEEN '$new7date' AND '$date' "; I query like this but no results are coming up. Does anyone have information on how I can do this?