Convert Unix Timestamp to Access 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?
 
A

Alex Dybenko

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
Date Timestamp 1
Convert sql2000 timestamp field 4
converting a hex timestamp to a readable date/time 1
Date to Unix time stamp? 2
Crosstab Query for Beginning Date and Ending Date 11

Top