I was asked to get the call details of a certain user then do it thru sql query on our pubs. I did get what I want...but the problem is, the date/time is not correct.
i found some formula conversion:
*convert from date/time:=(A2-DATE(1970,1,1))*86400
*convert to date/time==D2/86400+DATE(1970,1,1)
which worked but still the time is not correct...
Can anyone help me?