topic Re: Conversion of datetime to date in QlikView https://community.qlik.com/t5/QlikView/Conversion-of-datetime-to-date/m-p/617433#M479358 <HTML><HEAD></HEAD><BODY><P>I already have my timestamp off - But i just misunderstood my own data. So its okay <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Thu, 06 Feb 2014 16:46:34 GMT 2014-02-06T16:46:34Z Conversion of datetime to date https://community.qlik.com/t5/QlikView/Conversion-of-datetime-to-date/m-p/617431#M479356 <HTML><HEAD></HEAD><BODY><P>Hi -</P><P></P><P>What is the generel rule by convert a datetime to a date?</P><P></P><P>Eg in SQL cast('2014-01-15 03:00:00.00' as date) equals 2014-01-15 and then it spands from 2014-01-15 00:00:00.001 to 2014-01-15 23:59:59.999</P><P></P><P>But when i do this in Qlikview Date#(Date(CreateDate, 'YYYY-MM-DD') - then i dont get all my data (some of my data from the 15th is pushed back to the 14th.</P><P></P><P>How can i avoid this? </P></BODY></HTML> Thu, 06 Feb 2014 16:36:32 GMT https://community.qlik.com/t5/QlikView/Conversion-of-datetime-to-date/m-p/617431#M479356 2014-02-06T16:36:32Z Re: Conversion of datetime to date https://community.qlik.com/t5/QlikView/Conversion-of-datetime-to-date/m-p/617432#M479357 <HTML><HEAD></HEAD><BODY><P>Wrap your date field in floor():</P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>=date(floor(YourDateField))</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P></P><P>This will get rid of the timestamp.</P></BODY></HTML> Thu, 06 Feb 2014 16:45:06 GMT https://community.qlik.com/t5/QlikView/Conversion-of-datetime-to-date/m-p/617432#M479357 Nicole-Smith 2014-02-06T16:45:06Z Re: Conversion of datetime to date https://community.qlik.com/t5/QlikView/Conversion-of-datetime-to-date/m-p/617433#M479358 <HTML><HEAD></HEAD><BODY><P>I already have my timestamp off - But i just misunderstood my own data. So its okay <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Thu, 06 Feb 2014 16:46:34 GMT https://community.qlik.com/t5/QlikView/Conversion-of-datetime-to-date/m-p/617433#M479358 2014-02-06T16:46:34Z