hello i need to make a condition in my report where it will take the values from a sql database that were modified this month. in the db it is stored in this pattern-"April 2012" (for example). how can crystal report detect the month from this string? all i can think of is this. please help

cstr(monthname(month(currentdate)))+"-"+cstr(Year(CurrentDate))

yes, this solved my problem. thank you very much