Skip to Content
author's profile photo Former Member
Former Member

Date formatting problem

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 24, 2008 at 03:29 PM

    Victor, what version of Crystal Reports are you using?

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

    Ludek

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 24, 2008 at 03:44 PM

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

    Shawn

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.