I currently have a field coming out of a database with the call_time is
10 digit UTC format (simply the number of seconds that have passed from
that moment since 1970. I have converted it in Brio, but am not that
savy with VBA or Excel. Does anyone know how I can do this? I have
attached the script I use in Brio below:

CONVERT(VARCHAR(50),DATEADD(SS, (CALL_TIME + (1799-(((CALL_TIME %
86400)% 1800)))) - DATEDIFF(HH, GETDATE(),
GETUTCDATE()) * 3600, 'JAN
01, 1970 12:00AM'),114)

If anyone can help, I would REALLY appreciate it!!

Shawn.


--
smpayne69
------------------------------------------------------------------------
smpayne69's Profile: http://www.excelforum.com/member.php...o&userid=29307
View this thread: http://www.excelforum.com/showthread...hreadid=490251