Hi thanks for the reply, to be honest im working in asp, I now have the date working in a text field and it converts to sql format fine. However i would rather use the drop down lists so users cannot mistype the date, it is just how to convert the 3 values to one string that is getting me????? this is the only place i have seen the same question asked, can anyone help me??