Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using Qlik Sense and using Table. I have a date field that is mm/dd/yyyy (06/01/2017) but want it to be mmddyy (060117). is that even possible, of so how? Even when I import an excel spreadsheet with mmddyy; Qlik Sense coverts it back. I am new and trying to understand what Qlik can(not) do.
I reckon it could well because your default QlikSense date format is 'MM/DD/YY'.
Try forcing the field to your required format with something like :
Date( [YourDateField] , 'MMDDYY')