Skip to Content
0
Former Member
Aug 09, 2011 at 07:40 PM

Crystal reports - - Bad Date format

383 Views

Dear Experts,

I am using crystal developer 11. I am working with a 24 char strng that has a date (as a string) in the middle of it. I am using the mid function to extract the date two chars at a time because it includes the "/" char between each date part. I am then using Cdate to convert the resulting string to a date. I receive no errors when I check for errors, however, when I return to the main design and try to use this newly created date field against another actual date, I recieve an error "Bad Date format" back on the Cdate conversion in the formula. Is there a way to format this Cdate to avoid this error or possibly extract the date from the string and convert it to a date in a better way. Any help would be appreciated