topic How do I convert a 7 digit date? in QlikView https://community.qlik.com/t5/QlikView/How-do-I-convert-a-7-digit-date/m-p/457648#M170887 <HTML><HEAD></HEAD><BODY><P>I have a date field that is 7 digits long. The first 3 numbers are the year, the next two are the month, and the last 2 are the day. For example, I have 1040513 which I want to convert to 05/13/2004. Does anyone know what kind of format the first number is in? If the year is less than 2000, the number will be formatted as YYMMDD and I can work with that, but I haven't found a way to conver the years from 2000 and later.</P></BODY></HTML> Mon, 10 Jun 2013 20:21:20 GMT akile002 2013-06-10T20:21:20Z How do I convert a 7 digit date? https://community.qlik.com/t5/QlikView/How-do-I-convert-a-7-digit-date/m-p/457648#M170887 <HTML><HEAD></HEAD><BODY><P>I have a date field that is 7 digits long. The first 3 numbers are the year, the next two are the month, and the last 2 are the day. For example, I have 1040513 which I want to convert to 05/13/2004. Does anyone know what kind of format the first number is in? If the year is less than 2000, the number will be formatted as YYMMDD and I can work with that, but I haven't found a way to conver the years from 2000 and later.</P></BODY></HTML> Mon, 10 Jun 2013 20:21:20 GMT https://community.qlik.com/t5/QlikView/How-do-I-convert-a-7-digit-date/m-p/457648#M170887 akile002 2013-06-10T20:21:20Z Re: How do I convert a 7 digit date? https://community.qlik.com/t5/QlikView/How-do-I-convert-a-7-digit-date/m-p/457649#M170888 <HTML><HEAD></HEAD><BODY><P>Well, it's almost impossible to exactely know the format of your date with the information given, I think it's better to ask someone who actually knows the definition (or read the appropriate reference manual).</P><P></P><P>Could be something similar as described by Billy Brennan here:</P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/message/353919#353919">http://community.qlik.com/message/353919#353919</A></P><P></P><P>If it's something like this, you can do it like</P><P></P><P>Date( Date#(DateField + 19000000,'YYYYMMDD'), 'MM/DD/YYYY')</P></BODY></HTML> Mon, 10 Jun 2013 23:00:21 GMT https://community.qlik.com/t5/QlikView/How-do-I-convert-a-7-digit-date/m-p/457649#M170888 swuehl 2013-06-10T23:00:21Z