topic Date format to MMDDYY? in App Development https://community.qlik.com/t5/App-Development/Date-format-to-MMDDYY/m-p/1296130#M27410 <HTML><HEAD></HEAD><BODY><P>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?&nbsp; Even when I import an excel spreadsheet with mmddyy; Qlik Sense coverts it back.&nbsp; I am new and trying to understand what Qlik can(not) do.</P></BODY></HTML> Thu, 01 Jun 2017 15:56:43 GMT 2017-06-01T15:56:43Z Date format to MMDDYY? https://community.qlik.com/t5/App-Development/Date-format-to-MMDDYY/m-p/1296130#M27410 <HTML><HEAD></HEAD><BODY><P>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?&nbsp; Even when I import an excel spreadsheet with mmddyy; Qlik Sense coverts it back.&nbsp; I am new and trying to understand what Qlik can(not) do.</P></BODY></HTML> Thu, 01 Jun 2017 15:56:43 GMT https://community.qlik.com/t5/App-Development/Date-format-to-MMDDYY/m-p/1296130#M27410 2017-06-01T15:56:43Z Re: Date format to MMDDYY? https://community.qlik.com/t5/App-Development/Date-format-to-MMDDYY/m-p/1296131#M27411 <HTML><HEAD></HEAD><BODY><P>I reckon it could well because your default QlikSense date format is 'MM/DD/YY'.</P><P></P><P>Try forcing the field to your required format with something like :</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <EM>Date( [YourDateField] , 'MMDDYY')</EM></P></BODY></HTML> Thu, 01 Jun 2017 16:21:54 GMT https://community.qlik.com/t5/App-Development/Date-format-to-MMDDYY/m-p/1296131#M27411 Anonymous 2017-06-01T16:21:54Z