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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unix Timestamp to Access 2003 9
Convert Unix timestamp to Access 2003 data field 1
>> sql timestamp 4
How to convert a .msg File? 2
Best Way to Convert CSV Files to vCard? 1
Best Ways to Convert OST to PDF? 3
How Can I Convert MBOX to HTML File? 0
Date Timestamp 1

Back
Top