Code: Select all
DATE_FORMAT(dateoflastcontact, '%d/%m/%y')
AS dateoflastcontact, DATE_FORMAT(datecontactagain, '%d/%m/%y')
AS datecontactagain05/02/20
and when I enter 21-02-05 into datecontactagain (uk time format - dd-mm-yy) it gives me : 05/02/21
the mysql manual explains how to do it and I followed that to the letter plus some advice off this forum but still it remains the same?
Anyone got any advice or can anyone see anything wrong with this?