topic Date format with now() function in QlikView https://community.qlik.com/t5/QlikView/Date-format-with-now-function/m-p/207236#M63052 <HTML><HEAD></HEAD><BODY><P>Hi dsluga, take a look to the attacched qvw.</P><P>I'd suggest the use of today() function instead of now, if your goal is to show only the date.</P></BODY></HTML> Fri, 17 Sep 2010 16:40:49 GMT googel84 2010-09-17T16:40:49Z Date format with now() function https://community.qlik.com/t5/QlikView/Date-format-with-now-function/m-p/207235#M63051 <HTML><HEAD></HEAD><BODY><P>How do I get the =now(0) -1 functio to display a date time in a text box. It currently displays a number like 40437.1243. I've tried various date formats with no success. Thanks.<BR />Don</P></BODY></HTML> Fri, 17 Sep 2010 16:30:05 GMT https://community.qlik.com/t5/QlikView/Date-format-with-now-function/m-p/207235#M63051 2010-09-17T16:30:05Z Date format with now() function https://community.qlik.com/t5/QlikView/Date-format-with-now-function/m-p/207236#M63052 <HTML><HEAD></HEAD><BODY><P>Hi dsluga, take a look to the attacched qvw.</P><P>I'd suggest the use of today() function instead of now, if your goal is to show only the date.</P></BODY></HTML> Fri, 17 Sep 2010 16:40:49 GMT https://community.qlik.com/t5/QlikView/Date-format-with-now-function/m-p/207236#M63052 googel84 2010-09-17T16:40:49Z Date format with now() function https://community.qlik.com/t5/QlikView/Date-format-with-now-function/m-p/207237#M63053 <HTML><HEAD></HEAD><BODY><P>Here is the version with the entire timestamp.</P><P>Sorry for the misaunderstanding.</P><P></P></BODY></HTML> Fri, 17 Sep 2010 16:46:27 GMT https://community.qlik.com/t5/QlikView/Date-format-with-now-function/m-p/207237#M63053 googel84 2010-09-17T16:46:27Z Date format with now() function https://community.qlik.com/t5/QlikView/Date-format-with-now-function/m-p/207238#M63054 <HTML><HEAD></HEAD><BODY><P>Thank you for your help. I'll probably go with the now() function since I need to go to the hour and minute.</P><P>Don</P></BODY></HTML> Fri, 17 Sep 2010 16:50:39 GMT https://community.qlik.com/t5/QlikView/Date-format-with-now-function/m-p/207238#M63054 2010-09-17T16:50:39Z Date format with now() function https://community.qlik.com/t5/QlikView/Date-format-with-now-function/m-p/207239#M63055 <HTML><HEAD></HEAD><BODY><P>Try =date(now(0)-1)</P></BODY></HTML> Fri, 17 Sep 2010 19:28:37 GMT https://community.qlik.com/t5/QlikView/Date-format-with-now-function/m-p/207239#M63055 2010-09-17T19:28:37Z Date format with now() function https://community.qlik.com/t5/QlikView/Date-format-with-now-function/m-p/207240#M63056 <HTML><HEAD></HEAD><BODY><P>Thank you. That worked. <IMG alt="Smile" src="http://community.qlik.com/emoticons/emotion-1.gif" /></P></BODY></HTML> Fri, 17 Sep 2010 19:39:09 GMT https://community.qlik.com/t5/QlikView/Date-format-with-now-function/m-p/207240#M63056 2010-09-17T19:39:09Z