I am trying to create a formula that compares the month and year (eg. Dec 2009) from two date fields. If the the two date fields contain the same month and year the formula will print the invoice amount.
Any suggestions?
Thank you in advance.
lbass and Turkbear, thank you both for your suggestions.
Turkbear, I copied your revised code into my reports and with the exception of the last "and" it worked exactly as I had wanted. Thank you very much. This has saved me hours of head scratching.
I have created a report that has four dynamic parameters in Crystal XI r1. The list of values is supplied by a SQL Command that also includes the option “All”. I have also created a select formula that will display “All” records when all is selected, or the appropriate data when an item other...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.