Date formatting problem

[Former Member]

Can anybody help. I have a data source that stores the date as MM DD YYYYY. I need to use this field as selection criteria but the report fails when the day reaches 13. I've tried storing the field as text and manipulating it into DD MM YYYY but still no joy. It looks as soon as the field is read it fails as a valid date before I can manipulate it

I've tried CDATE but it didn't work

Any Ideas?

[former_member183750 · Accepted solution]

Victor, what version of Crystal Reports are you using?

When you say: "report fails", what does it do? Error(s)? Behavior details?, etc.?

Ludek

[Former Member · Accepted solution]

I'm using Crystal Reports XI. As for 'fails' I think it's the wrong word to use. If I display the database field when the date reaches 04/13/2007 (April 13th) a blank field is displayed. As a result any attempt to process the field as a string fails

[former_member183750 · Accepted solution]

If you are using CR XI r1, I'd recommend starting off with the latest SP:

https://smpdl.sap-ag.de/~sapidp/012002523100006008952008E/crXIwin_sp4.zip

Depending on what SP you are at, the above may install, or not. Let me know if not.

If you are on CR XI r2, you will need the SP from here:

https://smpdl.sap-ag.de/~sapidp/012002523100006255302008E/crxir2sp3_rdc_mm.zip

Same applies re. the SP installing or not.

Next; as Shawn asked, do you see the same behavior in the CR designer as in an application?

Also, what is the datasource you are using?

Ludek

[former_member203619]

Also Victor - does this fail when you view it in the report designer - or only when done through custom code?

Shawn