"Warning #1265 Data truncated for column 'dreamcarCOMPDATESTART' at row 1"
Thing is, the date picker on the website is inserting in UK format and the database accepts it and displays it properly. It's only the SELECT statement that's misinterpreting it.
Urggh, this is messy. What am I doing wrong?