Search results

Thanks for all the help, I got it to work finally. It wasn't the CDate function that wanted strings, but the left,right and mid functions that wanted strings. so I encapsulated the number in CSTR before I encapsulated it in left/right/mid and it worked. Thanks again. Jeff

I actually tried that, but the problem is that the Date stored in the database is in of type number, and cdate expects type string. Is there a way that I can first convert it to a string? Thanks again, Jeff

I am trying to create a report in Crystal Reports XI using DacEasy v 14. The problem I am having is that dates are stored in the following format in the database: YYYYMMDD for example 20080113 for 2008, Jan 13. How can I get it to convert that date and display a human readable date such...