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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with Date Format

Status
Not open for further replies.

IlseH

Programmer
Aug 28, 2001
10
BE
The dates in my database are stored as "mdy". When displaying the dates in Crystal Reports 8, the dates are mixed up.
Say I have two dates:
date1 is stored as 08/23/2001, date2 is stored as 10/03/2001.
When displaying the dates i get 23/08/2001 and 10/03/2001 where it should be 08/23/2001 and 10/03/2001 or 23/08/2001 and 03/10/2001.
How can I solve this?
 
Set the display format for each field that way
you want to see it.
 
Maybe I didn't express myself well enough. The dates I gave as an example come from the same field in the database, but from different records. Changing the display format does not solve my problem.
I even think the problem is related to my ODBC-connection. I work on a Progress 9.1B database and use "MERANT 3.60 32-BIT Progress SQL92 v9.1B" as ODBC-driver.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top