You need to sign in to do that
Don't have an account?
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?