I'm trying to pull a report out of an access database. I've got the whole thing structured like I want except I want to limit it to the previous month's numbers. My problem is the date field is a string coming from the database. I've tried using LastFullMonth but its looking for a date field xx/xx/xx and I'm shoving a string at it I know this isn't a good thing. Is there a way to convert my string to a date? Or perhaps another way at this problem?
I've thought also about trying to get the report to ask for a date range (as in one of the other posts) but I think I'll have the same problem once it looks at that "string".