Hi Rob,

This is definitely not a UTC conversion. I don't know what kind of notation
it is. The best way to converting this date is by using your own function.

For the date I used your crystal code as example and converted it to asp
code. Put the following code in an asp file and run it as example.

<%

Function DateConvert (OrgVal)
Dim TheYear
Dim TheMonth
Dim TheDay

TheYear = CInt(OrgVal / 65536)
TheMonth = CInt((OrgVal - (TheYear * 65536)) / 256)
TheDay = CInt(OrgVal - (TheYear * 65536) - (TheMonth * 256))

DateConvert = TheYear & " - " & TheMonth & " - " & TheDay
End Function



response.write "Date: " & DateConvert(131269907)

%>

I don't know how to convert the time. But it shouldn't be to hard if you
know how to do it with Crystal Reports.


Regards,

Ralphho
Microsoft