topic Epicor Software? in QlikView https://community.qlik.com/t5/QlikView/Epicor-Software/m-p/183500#M48737 <HTML><HEAD></HEAD><BODY><P>What version of epicor? I am loading the dates just fine, without formating they appear as MM/DD/YYYY 12:00:00</P><P></P><P>Using the date function in the load section converts just the date.</P></BODY></HTML> Fri, 11 May 2012 14:45:08 GMT 2012-05-11T14:45:08Z Epicor Software? https://community.qlik.com/t5/QlikView/Epicor-Software/m-p/183498#M48735 <HTML><HEAD></HEAD><BODY><P>Folks,</P><P>had anybody loaded data from Epicor Software? I can't convert their dates... They appear as some sort of Julian number, but it is not too clear what's the rule...</P><P>any input?</P><P>thanks!</P><P></P></BODY></HTML> Thu, 10 Dec 2009 22:34:37 GMT https://community.qlik.com/t5/QlikView/Epicor-Software/m-p/183498#M48735 Oleg_Troyansky 2009-12-10T22:34:37Z Epicor Software? https://community.qlik.com/t5/QlikView/Epicor-Software/m-p/183499#M48736 <HTML><HEAD></HEAD><BODY><P>Hi Oleg,</P><P>I've recently found a software with a singular date format from a SQL server, maybe my solution could be help you:</P><P>Load</P><P>ConvertToLocalTime("SubmitDate",'Madrid'),</P><P>....</P><P>SQL SELECT</P><P>cast(cast(Submit_Date as numeric) / 86400 as DateTime)+ cast('01/01/1970 01:00:00' as DateTime) as SubmitDate,</P><P>....</P><P>FROM ...</P><P>Best regards.</P><P></P></BODY></HTML> Thu, 10 Dec 2009 23:04:24 GMT https://community.qlik.com/t5/QlikView/Epicor-Software/m-p/183499#M48736 2009-12-10T23:04:24Z Epicor Software? https://community.qlik.com/t5/QlikView/Epicor-Software/m-p/183500#M48737 <HTML><HEAD></HEAD><BODY><P>What version of epicor? I am loading the dates just fine, without formating they appear as MM/DD/YYYY 12:00:00</P><P></P><P>Using the date function in the load section converts just the date.</P></BODY></HTML> Fri, 11 May 2012 14:45:08 GMT https://community.qlik.com/t5/QlikView/Epicor-Software/m-p/183500#M48737 2012-05-11T14:45:08Z