I was wondering if anyone could help, I am trying to get the date in my View to order in ascending order. Every time I try it keeps coming up with an error stating the syntax is wrong.

The code of the view is below:ALTER VIEW `MyFlights` AS SELECT DATE_FORMAT(`Flights`.`FlightDate`,'%d-%b-%Y') AS `FlightDate`, `Flights`.`Departed`, `Flights`.`Arrived`, `Flights`.`Airline`, `Flights`.`FltNo`, `Flights`.`ACReg`, `Flights`.`Aircraft` FROM `Flights` WHERE 1