Reading CDR with MSAccess

[jim.rowlan]

Does anyone know how to read the date/time fields in the CDR database with MSAccess? I've tried everything I know and have to be able to make it work.

Thanks,

Jim

[jaywydra]

this link will convert those values. I have not tried with MSAccess. Cisco also has a tool I believe.

http://www.jimworld.com/tools/unixtime/

[jcdurand]

This works in SQL, so it should work on Access. Good luck.

select dateadd(second,FIELDNAME,'01/01/1970') as ALIASNAME

[jim.rowlan]

BINGO! That worked. Only one thing I had to change. Instead of second, you use 's' I was on the right track, but using datediff. I got a result, but it was a bit into the future...like 2064!

THANKS!