topic Date calculation issue in QlikView https://community.qlik.com/t5/QlikView/Date-calculation-issue/m-p/220446#M73358 <HTML><HEAD></HEAD><BODY><P>Hi all, writing a piece to analyse data from one of our feedback systems. Problem is that it displays the date in format DD-MM-YYYY HH-MM-SS-MS what I want to be able to do is do some calculations based on these dates, so I can work out the days before calls are breached, and calculate the numbers of days since the call was raised and group these into a column of calls that are 1 day old, 2 days old etc etc. However when I try to do what should be a simple date-date calculation I just end up with null values, even when I perform a left(datefield,10) first of all to reduce the date to DD-MM-YYYY. Any ideas for solutions would be most welcome, please find the offending item attached!</P><P>Cheers</P><P>Ben</P></BODY></HTML> Fri, 22 Jan 2010 11:03:49 GMT 2010-01-22T11:03:49Z Date calculation issue https://community.qlik.com/t5/QlikView/Date-calculation-issue/m-p/220446#M73358 <HTML><HEAD></HEAD><BODY><P>Hi all, writing a piece to analyse data from one of our feedback systems. Problem is that it displays the date in format DD-MM-YYYY HH-MM-SS-MS what I want to be able to do is do some calculations based on these dates, so I can work out the days before calls are breached, and calculate the numbers of days since the call was raised and group these into a column of calls that are 1 day old, 2 days old etc etc. However when I try to do what should be a simple date-date calculation I just end up with null values, even when I perform a left(datefield,10) first of all to reduce the date to DD-MM-YYYY. Any ideas for solutions would be most welcome, please find the offending item attached!</P><P>Cheers</P><P>Ben</P></BODY></HTML> Fri, 22 Jan 2010 11:03:49 GMT https://community.qlik.com/t5/QlikView/Date-calculation-issue/m-p/220446#M73358 2010-01-22T11:03:49Z Date calculation issue https://community.qlik.com/t5/QlikView/Date-calculation-issue/m-p/220447#M73359 <HTML><HEAD></HEAD><BODY><P>Use of date#() would help you that with something like</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">date#(DateField, 'DD-MM-YYYY HH-MM-SS-FF')</PRE></BLOCKQUOTE>. Hope this helps. <BR /><BR /></BODY></HTML> Fri, 22 Jan 2010 14:10:39 GMT https://community.qlik.com/t5/QlikView/Date-calculation-issue/m-p/220447#M73359 Miguel_Angel_Baeyens 2010-01-22T14:10:39Z