Dealing with dates in string format

To change dates that are being tracked as strings into date format, you can try the following:

1. Change the Data type to string for the date field in question: http://recordit.co/lMmD3gDiw9

2. Add Cloud9QL to perform date formatting the way you would like the dates to display:

   Here's an helper for it: date_format(str_to_date(updated,yyyy-MM-dd HH:mm:ss),yyyy-MM-dd)