Formatting Dates in Data Assist
I have a MySQL database that I am using to display a schedule. I have entered all the tables set up and I have them populated with the necessary data. What I am trying to figure out is how make my table display the date field (entered into the database as a date (YYYY-MM-DD)) in the following format DAYOFTHEWEEK, MONTH DD, YYYY.
I'm guessing there is a very simple way to do this. Any help would be appreciated.
Thanks.