I am trying to convert a numeric field of data from a number to a date format so that I can filter by the date. As an example, my date comes in to Crystal as an 8 digit number. ex. 02062012. I need to convert that to a date field, preferably 02/06/2012 or with dots. Makes no difference. What I need to be able to do in the end is to run reports that I can then filter by date. Essentially I need an aging report, but I can't seem to figure out the right formula.

Please help!

thanks,

Jason