The question that elicits the answer "Hoy es miércoles" (Today is Wednesday) is:
¿Qué día es hoy? (What day is today?)
Simple, direct, and the standard way to ask for the current day of the week.