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)
Please sign in to leave a comment.