Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
"Even though the field is of type DATE in database" - which database are you loading from?
Can you please share your script to see exactly how you are loading the data?
IDBM DB2.
Just a simple select and load from tables.
Date format is set as 'yyyy-mm-dd'