I need to add an If statement within the following calculation that includes a date field in mm/dd/yyyy format to fall into the range for the final calculation:

Currently, the field reads:

If(Agency="ABC" and Gender = "Male", 1,0) or If (Agency="CDE" and Gender = "Male", 1,0)

I need to add:

If(Intake Date=07/01/2004...09/30/2004) in whatever format will work within this calculated field. I cannot process the report with the date criteria as a find script because the report must give date on a Quarter date range and a YTD date range.

Or, should I just create a date calculator that assigns a number to each day of the year. And, if this is how I should proceed, what is the easiest way to create the calculator?

Thanks!!

First of all, just to let you know, you can simplify your initial calculation so that it reads as follows:

( Agency = "ABC" or Agency = "CDE" ) and Gender = "Male"

This should have the same result as what you gave.



Second, I don't know where in your calc you want to add the date criteria, but if I understand what you want to do, this should return the correct results:

Intake Date > Date( 7, 1, 2004 ) and Intake Date < Date( 9, 30, 2004 )

Chuck