Convert Unix Timestamp to Access date

  • Thread starter Thread starter nms
  • Start date Start date
N

nms

I am working with a Remedy HelpDesk system that has an "arrivaltime" field
stored as a Unix timestamp that I need to convert to an Access date field to
be able to do a report by month (from 1 to 31 Dec for example). Does anyone
know an easy way to convert this "arrivaltime" field to an Access date field?
 
Hi,
not sure what are you talking about, but if this is a database, running on
Unix, then I would try to convert timestamp to text on a server. Text format
should be readable by access. you can make a new view for this and then
import or link it

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
Back
Top