Epicor Software?

[Oleg_Troyansky]

Folks,

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...

any input?

thanks!

[#2]

Hi Oleg,

I've recently found a software with a singular date format from a SQL server, maybe my solution could be help you:

Load

ConvertToLocalTime("SubmitDate",'Madrid'),

....

SQL SELECT

cast(cast(Submit_Date as numeric) / 86400 as DateTime)+ cast('01/01/1970 01:00:00' as DateTime) as SubmitDate,

....

FROM ...

Best regards.

[#3]

What version of epicor? I am loading the dates just fine, without formating they appear as MM/DD/YYYY 12:00:00

Using the date function in the load section converts just the date.