topic Re: How to change load format in QlikView https://community.qlik.com/t5/QlikView/How-to-change-load-format/m-p/457843#M1164262 <HTML><HEAD></HEAD><BODY><P>floor(MyDate) will remove the time fraction. Note, MyDate must be a date type and not a string. If it's a string you can use the date# function first to make it a date.</P></BODY></HTML> Fri, 26 Oct 2012 12:30:02 GMT Gysbert_Wassenaar 2012-10-26T12:30:02Z How to change load format https://community.qlik.com/t5/QlikView/How-to-change-load-format/m-p/457842#M1164261 <HTML><HEAD></HEAD><BODY><P>I am loading data from a data warehouse.&nbsp; I have are dates and some which are times.&nbsp; The times ones are fine but the date fields are loadign as dd/mm/yyyy hh:mm.&nbsp;&nbsp; As I already have a separate time field I don't require that portion of this field.&nbsp; Is there a simple way to correct this in the load statement.?</P><P></P><P>Help please</P></BODY></HTML> Fri, 26 Oct 2012 12:23:38 GMT https://community.qlik.com/t5/QlikView/How-to-change-load-format/m-p/457842#M1164261 2012-10-26T12:23:38Z Re: How to change load format https://community.qlik.com/t5/QlikView/How-to-change-load-format/m-p/457843#M1164262 <HTML><HEAD></HEAD><BODY><P>floor(MyDate) will remove the time fraction. Note, MyDate must be a date type and not a string. If it's a string you can use the date# function first to make it a date.</P></BODY></HTML> Fri, 26 Oct 2012 12:30:02 GMT https://community.qlik.com/t5/QlikView/How-to-change-load-format/m-p/457843#M1164262 Gysbert_Wassenaar 2012-10-26T12:30:02Z Re: How to change load format https://community.qlik.com/t5/QlikView/How-to-change-load-format/m-p/457844#M1164263 <HTML><HEAD></HEAD><BODY><P>Thank you -that works great. Now I've just got to take the seconds off one of my time fields so I can do utilisation.&nbsp; The data is all over the place, which just makes the development so much harder.</P></BODY></HTML> Fri, 26 Oct 2012 12:39:29 GMT https://community.qlik.com/t5/QlikView/How-to-change-load-format/m-p/457844#M1164263 2012-10-26T12:39:29Z Re: How to change load format https://community.qlik.com/t5/QlikView/How-to-change-load-format/m-p/457845#M1164264 <HTML><HEAD></HEAD><BODY><P>Thank you -that works great. Now I've just got to take the seconds off one of my time fields so I can do utilisation.&nbsp; The data is all over the place, which just makes the development so much harder.</P></BODY></HTML> Fri, 26 Oct 2012 13:47:42 GMT https://community.qlik.com/t5/QlikView/How-to-change-load-format/m-p/457845#M1164264 2012-10-26T13:47:42Z