topic Date calculation 2 quick queries in QlikView https://community.qlik.com/t5/QlikView/Date-calculation-2-quick-queries/m-p/224116#M76569 <HTML><HEAD></HEAD><BODY><P>Hi all, got two quick queries for you, hoping someone can help, much appreciated!</P><P></P><P>1. I have to do a date calculation on some old data like this:</P><P>(Today()-39) - Date[Datecalllogged] as [Name]</P><P>However at the moment the data isn't being updated what do I need to change so that the (today()-39) increases each day? So tomorrow its value is (Today()-40) how do you get it to update??</P><P>2. Once I've done this calculation I have the problem that Datecalllogged is in ddMMYYYY MMHHSSMM format and I only need the format in DDMMYYYY this means I end up with a Name value of 104.23244554 is there a way to get these calculations so I get a whole number instead? e.g. 104 straight away?</P><P></P><P>Hope that makes sense, thankyou all!</P><P>Ben</P></BODY></HTML> Wed, 27 Jan 2010 14:02:26 GMT 2010-01-27T14:02:26Z Date calculation 2 quick queries https://community.qlik.com/t5/QlikView/Date-calculation-2-quick-queries/m-p/224116#M76569 <HTML><HEAD></HEAD><BODY><P>Hi all, got two quick queries for you, hoping someone can help, much appreciated!</P><P></P><P>1. I have to do a date calculation on some old data like this:</P><P>(Today()-39) - Date[Datecalllogged] as [Name]</P><P>However at the moment the data isn't being updated what do I need to change so that the (today()-39) increases each day? So tomorrow its value is (Today()-40) how do you get it to update??</P><P>2. Once I've done this calculation I have the problem that Datecalllogged is in ddMMYYYY MMHHSSMM format and I only need the format in DDMMYYYY this means I end up with a Name value of 104.23244554 is there a way to get these calculations so I get a whole number instead? e.g. 104 straight away?</P><P></P><P>Hope that makes sense, thankyou all!</P><P>Ben</P></BODY></HTML> Wed, 27 Jan 2010 14:02:26 GMT https://community.qlik.com/t5/QlikView/Date-calculation-2-quick-queries/m-p/224116#M76569 2010-01-27T14:02:26Z