i am trying to connect directly to a databse where remedy data is stored. i founnd out that the date fields are on int datatype which do not convert directly to a date datatype. does anyone know how to deal with this issue? what algorithm does remedy uses to convert the data to a date format from an int datatype?

those dates are stored in epoch format, that is, seconds since jan 1, 1970... how to convert them depends on how you are accessing them... if you are using sql, there are to_date functions you can use, if you're using perl, you can convert it pretty easily...

just let us know how you're getting at the data, and we should be able to help you out...