I have a column in a data set that has dates in a string format YYYY-MM-DD.    How can I convert this into a date column?  ... View more

Hello    I currently have a table that has dates as a datetime fromat (example: 02FEB2015:00:00:00.000). I am trying to firgure out how I can convert this column into a string so it matches up with another table  with there date fromat as 2015-02-01 (as a string). I know there is the CAT funtcion but I do not know how to only select parts of the DAte time format to create the date string.    I have tried converting it in a query builder with the following steps ( look at attchement for screenshots) 1.I put the datetime column in the select data field  2.select properties 3. change 4. selected the format that matched the other field. once i did this the dates were no longer the same then what they were . The year was showin 1900 when all the years are 2015 etc.   What would be the best way to get it in sring fromat by YYYY-MM-DD?     then selected the datetime column and selected properies  ... View more