topic Date and Time from functions in QlikView https://community.qlik.com/t5/QlikView/Date-and-Time-from-functions/m-p/983020#M335482 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I wanted to display the current time like DD/MM/YYYY HH:MM:SS</P><P></P><P>Ex: 23/12/2015 23:13:21</P><P></P><P>Thanks,</P></BODY></HTML> Wed, 23 Dec 2015 17:44:10 GMT 2015-12-23T17:44:10Z Date and Time from functions https://community.qlik.com/t5/QlikView/Date-and-Time-from-functions/m-p/983020#M335482 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I wanted to display the current time like DD/MM/YYYY HH:MM:SS</P><P></P><P>Ex: 23/12/2015 23:13:21</P><P></P><P>Thanks,</P></BODY></HTML> Wed, 23 Dec 2015 17:44:10 GMT https://community.qlik.com/t5/QlikView/Date-and-Time-from-functions/m-p/983020#M335482 2015-12-23T17:44:10Z Re: Date and Time from functions https://community.qlik.com/t5/QlikView/Date-and-Time-from-functions/m-p/983021#M335483 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>TimeStamp(Now(1), 'DD/MM/YYYY hh:mm:ss')</STRONG></P></BODY></HTML> Wed, 23 Dec 2015 17:45:11 GMT https://community.qlik.com/t5/QlikView/Date-and-Time-from-functions/m-p/983021#M335483 sunny_talwar 2015-12-23T17:45:11Z Re: Date and Time from functions https://community.qlik.com/t5/QlikView/Date-and-Time-from-functions/m-p/983022#M335484 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny worked well.</P><P></P><P>Thanks,</P></BODY></HTML> Wed, 23 Dec 2015 17:59:21 GMT https://community.qlik.com/t5/QlikView/Date-and-Time-from-functions/m-p/983022#M335484 2015-12-23T17:59:21Z