Discussion Board for collaboration on QlikView Scripting.
Hi, I'm newish to QV
I've loaded in data via Sql 2008 and QVD files. One column has the datetime data type (im not allowed to change anything in the SQL DWH) i need to change it ro just Date in the QV.
What's the best and easiest way to do this.
Thanking you guys in advance.
Solved! Go to Solution.
Format or Value !
This 2 anwsers are corrects but the restult is different. You need to understand the difference.
Er.mohit give you a solution to change your field format. QlikView will present you a Date format but the value will still be a timestamp (date & time).
Gysbert Wassenaar change your field value from a timestamp to a date (no more time).
if your problem is resolved then you have to mark it either correct or helpful answer to closed this thread.so that it might be helpful for other developer.