Convert Unix timestamp to Access 2003 data field

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?
 
M

Marshall Barton

nms said:
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?
Click to expand...


Please don't post the same questions multiple times.

I think I answered this same question in another newsgroup.
 

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

Convert Unix Timestamp to Access date 1
Unix Timestamp to Access 2003 8
Date Timestamp 2
converting a hex timestamp to a readable date/time 1
Crosstab Query for Beginning Date and Ending Date 11
Autonumber field in Excel that behaves the same as Access 0
HOW TO OBTAIN ONLY THE DATE OF A timestamp FIELD 3
Convert Unix column to date and time in 2 columns 2

Top