Time returned reduced by one second

[vbredpgr]

I have a Crystal report (version 9) that is called from an application that is written in VB 6. The report is displayed on a VB form using the crystal viewer control.

The problem that I'm having is a date/time field is getting reduced by one second when it is displayed in the report. For example '1/1/1900 15:49:00' in the SQL database is displayed in the report as:

'1/1/1900 15:48:59'

This happens with other times but is most consistent with this time of day ('1/1/1900 15:49:00'). It doesn't reduce it by once second when it is run from the Crystal application.

Thanks in advance for any insight into this problem.

 

[Madawc]

I suspect rounding. Try showing tenths and hundredths of a second.



Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[vbredpgr]

Madawc,

Do you know of a way to show tenths or hundredths of a second in Crystal? I've looked for functions in the version of Crystal (v. 9) that I'm using but can't seem to find anything that will display these precisions of time.

Thanks.

 

[Madawc]

Look at ToText, date and time displays

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10