topic Date and Time fields in QlikView https://community.qlik.com/t5/QlikView/Date-and-Time-fields/m-p/256238#M96948 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>If i have a field being pulled through as a date and time field e.g.01/01/2012 08:56, in the script how can i just pull in the time? e.g. 08:56 </P><P></P><P>Thanks</P><P></P><P>Emma </P></BODY></HTML> Fri, 06 Jan 2012 11:35:13 GMT 2012-01-06T11:35:13Z Date and Time fields https://community.qlik.com/t5/QlikView/Date-and-Time-fields/m-p/256238#M96948 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>If i have a field being pulled through as a date and time field e.g.01/01/2012 08:56, in the script how can i just pull in the time? e.g. 08:56 </P><P></P><P>Thanks</P><P></P><P>Emma </P></BODY></HTML> Fri, 06 Jan 2012 11:35:13 GMT https://community.qlik.com/t5/QlikView/Date-and-Time-fields/m-p/256238#M96948 2012-01-06T11:35:13Z Date and Time fields https://community.qlik.com/t5/QlikView/Date-and-Time-fields/m-p/256239#M96949 <HTML><HEAD></HEAD><BODY><P>Hi emma,</P><P></P><P>you can use the function TIME in your script, it works well.</P><P></P><P>Regards</P><P></P><P>Johann</P></BODY></HTML> Fri, 06 Jan 2012 12:52:09 GMT https://community.qlik.com/t5/QlikView/Date-and-Time-fields/m-p/256239#M96949 jchoucq 2012-01-06T12:52:09Z