topic Re: how to remove time stamp in QlikView https://community.qlik.com/t5/QlikView/how-to-remove-time-stamp/m-p/243424#M92954 <HTML><HEAD></HEAD><BODY><P> hei </P><P>please check attach example</P><P>basicly i used a floor function on the order date field</P><P>which remove the hour parts from the filed</P></BODY></HTML> Sun, 01 Jan 2012 09:48:04 GMT lironbaram 2012-01-01T09:48:04Z how to remove time stamp https://community.qlik.com/t5/QlikView/how-to-remove-time-stamp/m-p/243423#M92953 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a question</P><P>i have a table which contain two fields ( Sub_Order , Order_Date )</P><P>Order_Date are in timestamp format</P><P>i want to relate this table date to the calendar via (Order_Date)</P><P>but this can't be done because of the timestamp in the order_Date</P><P>so,when i select certian sub_order it doesn't reflect in the calendar</P><P>How to remove that and make my selection of certian sub_Order affect the Calendar??</P><P></P><P>Best Regards,</P><P>Mona</P></BODY></HTML> Sun, 01 Jan 2012 09:35:44 GMT https://community.qlik.com/t5/QlikView/how-to-remove-time-stamp/m-p/243423#M92953 2012-01-01T09:35:44Z Re: how to remove time stamp https://community.qlik.com/t5/QlikView/how-to-remove-time-stamp/m-p/243424#M92954 <HTML><HEAD></HEAD><BODY><P> hei </P><P>please check attach example</P><P>basicly i used a floor function on the order date field</P><P>which remove the hour parts from the filed</P></BODY></HTML> Sun, 01 Jan 2012 09:48:04 GMT https://community.qlik.com/t5/QlikView/how-to-remove-time-stamp/m-p/243424#M92954 lironbaram 2012-01-01T09:48:04Z how to remove time stamp https://community.qlik.com/t5/QlikView/how-to-remove-time-stamp/m-p/243425#M92955 <HTML><HEAD></HEAD><BODY><P>Thanks Liron</P><P>it works <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sun, 01 Jan 2012 11:47:40 GMT https://community.qlik.com/t5/QlikView/how-to-remove-time-stamp/m-p/243425#M92955 2012-01-01T11:47:40Z