just to clarify i managed to get the insert date column working but only after i had changed to varchar which is no use at all really. at first glance i thought it had worked on one of my tables but did not do the trick at all.
need to change to varchar, which is where i am having trouble. i need to search by dates and it needs to submit into uk date format into db and retrieve like that.
sorry for any confusion dylan.