Printable View
hi,
the problem that I faced, is in a crystal report when i pass a date in to the report from VB, i get a different date!
in my database field date is : 10/5/2001
i get in crystal report : 25/4/1989
i couldn’t get a same time as in database.
has anyone overcome this problem?
I am new to VB, but know crystal, so I don't know how much help this is. It depends on several things. the db your pulling from (sql, access, oracle) the version of crystal you're on, and possibly your default settings in the report design. For the most part crystal receives dates best in the following format:
Date(yyyy, mm, dd, hh, mm, ss)
The date and () are to be included. You can drop the hh,mm,ss if you don't want the date time field.
I have seen many weird dates display in crystal because of not using the above format.
thanx mmhepb,
I use CR that comes with vb6, also I use access with DAO, and programmatically seems okay, there is no error, my code is:
cryWared_date.ReportFileName = "C:\wared\wared_date.rpt"
cryWared_date.DataFiles(0) = "c:\wared\creat_tab.mdb"
cryWared_date.Destination = crptToWindow
cryWared_date.Action = 1
I hope my question is clear.
Check the Dateformat in MsAccess. Because crystal will simply displays the List getting from database.
Crystal does't has a chance to chage the format.