topic Dates (Scripting) in QlikView https://community.qlik.com/t5/QlikView/Dates-Scripting/m-p/400497#M698024 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have four date fields part of the same table:</P><P>1. A - Start Date</P><P>2. A - Stop Date</P><P>3. B - Start Date</P><P>4. B - Stop Date</P><P></P><P>Now while loading this table I want to convert four date fields into two by picking Max dates from ( A- Start Date and B - Start Date) = New Start Date and similarly</P><P>max (A-Stop Date and B- Stop Date) = New Stop DAte</P><P></P><P>Thanks,</P><P>H</P></BODY></HTML> Mon, 04 Feb 2013 15:53:02 GMT hkg_qlik 2013-02-04T15:53:02Z Dates (Scripting) https://community.qlik.com/t5/QlikView/Dates-Scripting/m-p/400497#M698024 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have four date fields part of the same table:</P><P>1. A - Start Date</P><P>2. A - Stop Date</P><P>3. B - Start Date</P><P>4. B - Stop Date</P><P></P><P>Now while loading this table I want to convert four date fields into two by picking Max dates from ( A- Start Date and B - Start Date) = New Start Date and similarly</P><P>max (A-Stop Date and B- Stop Date) = New Stop DAte</P><P></P><P>Thanks,</P><P>H</P></BODY></HTML> Mon, 04 Feb 2013 15:53:02 GMT https://community.qlik.com/t5/QlikView/Dates-Scripting/m-p/400497#M698024 hkg_qlik 2013-02-04T15:53:02Z