I have two tables and one of them have a date field called "AnswerCreated" and the format for that field is "2014-02-04 19:42:22.130" and when I look at it in QV "41407,71546412".
I would like to use that field as a key to a Calendar but what is the best way to format that field?
Answer: LOAD AnswerCreated, date(floor(AnswerCreated)) as Date, Metaparenttype FROM D:\QV_Data\Admin\QVDs\MIS_Quiz.qvd (qvd);
You have dates without time in Calendar, but timestamps (dates with time) in Answer. Function floor() removes the time part. Function date() formats it as date as define in your "SET DateFormat", so it is the same as in Date in Calendar.
