While loading a date field in Qliksense, it is not showing the format correctly. Even though the field is of type DATE in database, while loading and viewing the preview in metadata it adds a timestamp. Eg: Date is 2019-01-01, it reads it as 2019-01-01 00:00:00.000000. While trying to extract only the date part using Date(date_field) , it gives wrong values for month. eg: 2019-00-01. please suggest how to solve this issue.
