topic Date format in QlikView https://community.qlik.com/t5/QlikView/Date-format/m-p/277197#M1205035 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a date field as 25012007 (january 25 , 2007) so in the text format 'DDMMYYYY'</P><P>What is the best way to transform this field in a date format 'YYYY/MM/DD' in the script.</P><P></P><P>Regards</P><P>JJ</P><P></P></BODY></HTML> Thu, 16 Sep 2010 18:17:08 GMT 2010-09-16T18:17:08Z Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/277197#M1205035 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a date field as 25012007 (january 25 , 2007) so in the text format 'DDMMYYYY'</P><P>What is the best way to transform this field in a date format 'YYYY/MM/DD' in the script.</P><P></P><P>Regards</P><P>JJ</P><P></P></BODY></HTML> Thu, 16 Sep 2010 18:17:08 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/277197#M1205035 2010-09-16T18:17:08Z Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/277198#M1205036 <HTML><HEAD></HEAD><BODY><P></P><P></P><P>=</P><P><B>date</B>(<B>date#</B>(DateField, 'DDMMYYYY'), 'YYYY/MM/DD')</P><BR /><BR /> <BR /><BR /></BODY></HTML> Thu, 16 Sep 2010 18:22:08 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/277198#M1205036 Anonymous 2010-09-16T18:22:08Z Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/277199#M1205037 <HTML><HEAD></HEAD><BODY><P>Hi, you can use</P><P>date(date#(DATE_FIELD,'DDMMYYYY'),'YYYY/MM/DD') as field_YYYYMMDD</P><P>this is going to transform the original in a field with the format YYYYMMDD, but internally it's going to be a date, so you can use year(), month() etc..</P><P></P><P>rgds.</P><P></P><P></P></BODY></HTML> Thu, 16 Sep 2010 18:24:14 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/277199#M1205037 hector 2010-09-16T18:24:14Z Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/277200#M1205038 <HTML><HEAD></HEAD><BODY><P>LOL</P><P>2 minutes of difference xD</P></BODY></HTML> Thu, 16 Sep 2010 18:25:14 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/277200#M1205038 hector 2010-09-16T18:25:14Z Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/277201#M1205039 <HTML><HEAD></HEAD><BODY><P>Tx Michael for your help</P></BODY></HTML> Thu, 16 Sep 2010 18:29:21 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/277201#M1205039 2010-09-16T18:29:21Z Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/277202#M1205040 <HTML><HEAD></HEAD><BODY><P>Tx Hector for your help - LOL</P></BODY></HTML> Thu, 16 Sep 2010 18:29:58 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/277202#M1205040 2010-09-16T18:29:58Z