I have a crystal report that has a field showing a date, but it comes in as a text field. I need to compare this field to the current date, so that the report will only display records where the date's field is within the current month. Is there a way to do reference modification, where I can start with the first character in the field, and take, say 2 characters? Or is there another way to do this?

Any help and ideas will be greatly appreciated.

Thanks in advance,
Jessica