Anyone know Mattec? 6

[jasonmac]

Hi everyone. This is just a shot in the dark but here's what I got.

We have this system called Mattec that keeps track of our production. It's based on SQL server. I'm not sure what version. I'm trying to make a report in access using some of the data in the system. When I bring the a date/time field into Access it looks like this. 978595471. I need to convert that into a proper date and time. Does anyone know what I'm talking about or run into something similar when working with SQL Server?

Thanks,
Jason

 

[jasonmac]

That did the trick. Thanks again! The first example I gave you was wrong on my end.