Straing a SiB with QlikSense and having issues with Date FOrmats.
I have my date format set correctly to MM/DD/YYYY
I am loading date from SQL table which has time so using the floor(date(datefield,'MM/DD/YYYY')) in load script for each datetime field.
Result in the application is the number format of the date instead of the date format above. What am I missing? There do not appear to be any options to format the date dimensions in the desktop except in the script. In QV, we can format in object or in document properties. Sense has neither option that I am aware of.