Need Help Debugging LastYearMTD issue

[BHaines]

Using Crystal 8.5. According to Crystal Help, the LastYearMTD function does the following:

"Specifies a range of Date values in the previous year that matches the current month to date."

I'm trying to use it as a stepping stone to reporting based on activity in each of the last 12 months. We are capturing a date/time field this is based off of, so I tried extracting just the date then getting it to report back to me a 1 or a 0 if the date fell within the last 12 months. All were 0s regardless of when the date was. I then tried to get it to give me a 'Yes' or 'No' string, and it too failed. Here is the formula at current, and any help would be much appreciated.

IF Date({S_CUST_SURVEY.LAST_UPD}) In LastYearMTD Then "Yes" Else "No"

 

[BHaines]

*facepalms* And this is why you shouldn't do CR when sleep deprived. I needed to use LastYearYTD instead. I read the wrong section of the help file. Ignore the request.