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 9
Date Timestamp 1
Crosstab Query for Beginning Date and Ending Date 11
Numeric Field Overflow when appending date - how to convert it to text 1
Convert sql2000 timestamp field 4
how do I extract pieces of data from a field 2
HOW TO OBTAIN ONLY THE DATE OF A timestamp FIELD 3

Top