Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server datetime fields not displaying

Status
Not open for further replies.

delu0007

Programmer
Aug 28, 2001
26
US
I have a report based on a SQL Server database. All of the datetime fields display as 'Jan 01, 4294962583 12:00:00 AM'. If I choose the "Browse Field Data" option, all the datetime values appear correctly in the list. I have checked in File-Report Options and the 'Convert Date-Time Field' option is set to 'To Date-Time'. Any suggestions?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top