I am wanting to populate a datetime field with data retrieved from 4 dropdowns month, day, year and hour 08:00 - 18:00.

I am having trouble joining them together in a format that the sql server recognises.