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 8
Convert Unix timestamp to Access 2003 data field 1
How to use/create code in MS Word to calculate age? 0
>> sql timestamp 4
Reading Metadata from Word Documents 0
How to remove a bracket that is itallicised for an entire document 1
Creating Forms 0
Date Timestamp 2

Top