+ Start a Discussion
Eager-2-LearnEager-2-Learn 

Reports and Criteria

Hello,

 

Is there a way to put functions inside a report criteria?  For example, if I set the operator to CONTAINS I do not want to hard code a month.  What I really need to know is that the opportunity field DESCRIPTION contains 09/**/09.  The problem is we have the users enter mm/dd/yy as the first part of a line in the description.  This helps know when they added the comment but they may enter mm/dd/yy or mm/dd/yyyy!  I just want to catch mm and yy of the current date that it runs.  I tried something like MONTH(Today()) but it did not work.

 

So can we use functions in report criteria and if we can can you provide a link to help on this and an example?

 

Best Answer chosen by Admin (Salesforce Developers) 
tstrongtstrong
You can't use formula functions in a report, but you could create a new formula field on your opportunity to get your comment date, and then use evaluation criteria on that field.  So filter on something like if the formula field = THIS MONTH or LAST MONTH.