Thank you ... guess I didn't look back far enough.
>>Anybody know what the format is of the TimeStamp field in a VCX or SCX?
>
>Check
Re: Decode VCX timestamp? Thread #
1098675 Message #
1098679>
>
MSDN Reference>
>
http://blogs.msdn.com/calvin_hsia/archive/2005/01/21/358339.aspx>
>
>PROCEDURE DecodeTimeStamp(nTimestamp as Number) as Datetime
>
> nDate=BITRSHIFT(nTimestamp,16)
>
> nTime=BITAND(nTimestamp,2^16-1)
>
>
>
> nYear=BITAND(BITRSHIFT(nDate,9),2^8-1)+1980
>
> nMonth=BITAND(BITRSHIFT(nDate,5),2^4-1)
>
> nDay=BITAND(nDate,2^5-1)
>
>
>
> nHr=BITAND(BITRSHIFT(nTime,11),2^5-1)
>
> nMin=BITAND(BITRSHIFT(nTime,5),2^6-1)
>
> nSec=BITAND(nTime,2^5-1)
>
>
>
> RETURN DATETIME(nYear,nMonth,nDay,nHr,nMin,nSec)
>
>RETURN
>
>
Jim Nelson
Newbury Park, CA