Connecting text field to Database Based on Day of the Week

I want to connect a text field to a different column in my database based on the day of the week. I am having trouble finding documentation for how to do this online.