Unable to convet to Time

[Guest_imported]

Iam working in Lotus Notes.
iam trying to connect Lotus with Crystal Reports.
everything is fine except the time variable.it is storing fine in Lotus,but in reports it is converted to an Integr value like 2634343.pls help me how to convet this number to time.
Or other wise tell me how to get the value from Lotus as it is to Front End reports.
Thanks
Pavan

 

[kcopeland]

The DateValue funtion may give you your answer.

however DateValue (2634343)= "08/01/9112".

 

[jjames]

Take a look at the TimeValue function. This converts to a valid time only if the number is on the right side of the decimal point. ie; TimeValue(.2634343) converts to 06:19:21