Date & Time Stamp Conversion 1

[Alfagomma]

Hello everyone,
I would like to know how to convert an AUDTTIME field content into a readable format. I am not sure how the number (looks like an integer) is recorded, initially I thought it was the number of seconds elapsed since midnight - but it's not.
Thanks in advance

 

[Jay Converse]

It's GMT. Using Crystal, use the pwformattime() function.

 

[Alfagomma]

tuba2007,
Thanks alot for your reply, I shed some light on this issue.
For anybody's benefit, if you ever need to manipulate the content of the field AUDTTIME when in Excel/VBA using ODBC, xapi, etc. the format of the field is hhmmsshh (thanks to JayConverse previous post). The first 4 digits (hhmm) will have to be converted from GMT to local time. To achieve this:

http://www.cpearson.com/excel/timezone.htm

(since Excel only uses local time).
Thanks alot again, you guys rock.