topic round up dates in QlikView https://community.qlik.com/t5/QlikView/round-up-dates/m-p/629485#M1089212 <HTML><HEAD></HEAD><BODY><P>Hi all </P><P></P><P>i'm having a date round up issue </P><P>both dates look in the GUI the same but apparently one is bigger than the other <IMG src="https://community.qlik.com/legacyfs/online/emoticons/angry.png" /></P><P>how can i round them up the two dates</P><P>Thanks </P><P>J</P><P></P><P></P><P>Date((date#(left(Day,12),'MMM DD, YYYY') +Maketime(hour([R_ Time]))),'MM.DD.YY hh:mm')&nbsp;&nbsp;&nbsp; AS 111</P><P>&nbsp; </P><P>Date (timestamp#(left(Time,16),'YYYY/MM/DD hh:mm'),'MM.DD.YY hh:mm' )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AS&nbsp; 2222</P></BODY></HTML> Tue, 27 May 2014 13:06:08 GMT Anonymous 2014-05-27T13:06:08Z round up dates https://community.qlik.com/t5/QlikView/round-up-dates/m-p/629485#M1089212 <HTML><HEAD></HEAD><BODY><P>Hi all </P><P></P><P>i'm having a date round up issue </P><P>both dates look in the GUI the same but apparently one is bigger than the other <IMG src="https://community.qlik.com/legacyfs/online/emoticons/angry.png" /></P><P>how can i round them up the two dates</P><P>Thanks </P><P>J</P><P></P><P></P><P>Date((date#(left(Day,12),'MMM DD, YYYY') +Maketime(hour([R_ Time]))),'MM.DD.YY hh:mm')&nbsp;&nbsp;&nbsp; AS 111</P><P>&nbsp; </P><P>Date (timestamp#(left(Time,16),'YYYY/MM/DD hh:mm'),'MM.DD.YY hh:mm' )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AS&nbsp; 2222</P></BODY></HTML> Tue, 27 May 2014 13:06:08 GMT https://community.qlik.com/t5/QlikView/round-up-dates/m-p/629485#M1089212 Anonymous 2014-05-27T13:06:08Z